Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MsHart2u

    Need to Repeat Header in rows 1 thru 3

    I have a finished SSIS package in Visual Studio 2008R2 that runs beautifully: 1. exports SQL data into a flat file destination with 1 header row, 2. renames the file to include the date in file name 3. Finally, it FTPs this file to our vendors destination for upload PROBLEM: recipient wants...
  2. MsHart2u

    Need to Void Orders using SQL

    I ran the following query to determine open orders that should be voided. After reviewing and approving them, we need to know how we can void these orders using SQL. We have over 30K order #'s in this results set. SELECT distinct ca.custname, ca.CUSTNMBR...
  3. MsHart2u

    My changed Stored Procedures in SQL are not changed in SSIS

    let me try again. I have 7 stored procedures in 7 tasks within 1 package, called BW_exports, of SSIS. Each task runs a separate sp. I got replies Monday from our vendor that required fixes to 3 of the sp. Fixes are in. :) I tested and recreated the sp by doing the drop and create, perhaps I...
  4. MsHart2u

    My changed Stored Procedures in SQL are not changed in SSIS

    I should tell you, I have all this in a package in SSIS on SQL SERVER 2008 in 32 bit environment. Thanks again!! Kathy, Bus Sys Analyst "I am always doing that which I can not do, in order that I may learn how to do it."– Pablo Picasso The person who says it can't be done shouldn't...
  5. MsHart2u

    My changed Stored Procedures in SQL are not changed in SSIS

    Hi, I am calling 7 separate stored procedure via the SQL command tasks using " exec <sp_name>" as query commands exporting to flat files. They are running with no errors... BUT today I made changes/improvements to 3 of the Stored procedures in SQL to the stored procedures. I ran the SQL to...
  6. MsHart2u

    DW QA testing

    Hi, We hve been asked to research and advise on the best QA practices for Data Warehouses, with the main focus on the number of years of data commonly used when testing. We are using MS SQL Server. If anyone can help or advise on a formula, etc to help with ourdecisions or some websites...
  7. MsHart2u

    Save as pipe delimited in Excel using VBA

    Can you please tell me how I can Save an Excel worksheet as pipe delimited text file, using VBA? Thank you in advance. Kathy, Bus Sys Analyst "I am always doing that which I can not do, in order that I may learn how to do it."– Pablo Picasso The person who says it can't be done shouldn't...
  8. MsHart2u

    MS Excel VBA to Access Runtime error -2147467259

    Again, you are awesome and quick!!! Kudos and congrats on winner of the week. Kathy, Bus Sys Analyst "I am always doing that which I can not do, in order that I may learn how to do it."– Pablo Picasso The person who says it can't be done shouldn't interrupt the person who is doing it.—Chinese...
  9. MsHart2u

    MS Excel VBA to Access Runtime error -2147467259

    Thank you...So my script has progressed and looks like this but returns and an empty recordset. Please advise as to what I am doing wrong. '*****BEGIN ******* ' open the database Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & DBFullName &...
  10. MsHart2u

    MS Excel VBA to Access Runtime error -2147467259

    I've searched the blogs and cannot find my scenario, in trying to debug... I am using Excel 2000 to connect to Access 2000. I get this Runtime error -2147467259 Automation error Unspecified error. My basic goal is to connect to Access and retrieve a record set into a temp table. Any help...
  11. MsHart2u

    Stored Procedure to Insert Records

    Thank you for your constructive input. I changed my plus(+) to || as you advised. I am a newbie to Oracle, the reference book I inherited is 8i, but the server verison is actually 9.2.0.1 so I will change forums. Your advice worked as does my script now. Thanks a heap, Mufasa. Kathy, Bus Sys...
  12. MsHart2u

    Stored Procedure to Insert Records

    I am attempting to create a stored proc (my first using Oracle)... It gives me 2 blasted error messages. Please tell what I am missing... I cannot see it. I have counted my columns and I get equal counts on the select and the insert.(arrrgggghhh!!!) Error Message 1 Line 21 Col 1 PL/SQL...
  13. MsHart2u

    Select First instance of set per

    SQLDenis, Bless you, thank you! Thank you. Bless You!! This is perfectly the help I needed!!! Kathy, Bus Sys Analyst "I am always doing that which I can not do, in order that I may learn how to do it."– Pablo Picasso The person who says it can't be done shouldn't interrupt the person who is...
  14. MsHart2u

    Select First instance of set per

    Thank you for the feedback. Unfortunatley, removing this from the group gets me one record, the 1st month, but I need the 1st month where the quantity total is above 5. Kathy, Bus Sys Analyst "I am always doing that which I can not do, in order that I may learn how to do it."– Pablo Picasso...
  15. MsHart2u

    Select First instance of set per

    I am attempting to retrieve the 1st instance this rule is met for each prodcode. The broken query is as follows: SELECT p.ProdCode, Min(Month([post])) AS Mth, p.Title FROM tbl_invtrans d RIGHT JOIN tbl_product p ON d.prodcode = p.ProdCode WHERE (((p.Pub_Date)>'2004-12-01') AND...
  16. MsHart2u

    Update multiple fields using Inner Join and an if or where

    Thanks alot hmckillop. Your Update-Case statement worked perfectly! Kathy When you dig another out of their troubles, you find a place to bury your own.—Anonymous The person who says it can't be done shouldn't interrupt the person who is doing it.—Chinese Proverb
  17. MsHart2u

    Update multiple fields using Inner Join and an if or where

    What is the best way to update multiple fields in a record only if the values are different? Ive tried the following two scripts to only receive errors... ############# 1 ################## UPDATE tbl_title set retail_us = tbl_scan_temp.retail_us where (retail_us <>...
  18. MsHart2u

    Looping and Cross Joins with Cursors...

    This worked perfectly!!!... Thank you for the help. Kathy When you dig another out of their troubles, you find a place to bury your own.—Anonymous The person who says it can't be done shouldn't interrupt the person who is doing it.—Chinese Proverb
  19. MsHart2u

    Looping and Cross Joins with Cursors...

    Here is my dilemma... I have inherited a DTS package that has the following script in it over 50 times. <SCRIPT BEGIN > INSERT INTO tbl_sold (import_date, isbn, week_num, area, units) SELECT vw_current_week.Import_Date, tbl_records_temp.isbn, vw_current_week.week_num, 'area68' AS...
  20. MsHart2u

    COPY ERROR: Extra data after last expected column

    Real simple. (Can you tell I'm frustrated), I created a table like so: CREATE table test(colA int4, colB varchar(10) NOT NULL, colC date, colD text); I have tab delimited text file being ftp'd to my linux box daily that looks like this (the 4th column is just a tab, I cannot get rid of): 3550...

Part and Inventory Search

Back
Top