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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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