Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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 <>...

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...

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...

revisiting a script I am working on, Script works brilliantly, except that I need help on fixing the length of 2 text fields to be required lengths of 30 and 15, respectively. Ideally, I am attempting to create and export from SQL fixed length records. Please advise The code used in...

I hate to be redundant in asking for help on a problem already solved and I am attempting to use either of the recommended solutions listed in FAQ183-2146 (Concatenating a one-to-many relationship into a single column) with a twist. Let me say this faq was tremendously helpful, enlightening has...