August 7, 2009 at 7:54 am
Using SQL 2005 Sp2 in 64 bit environment. Installed the SQL 2000 DTS Designer Components onto the SQL 2005 SQL server. Have existing 2000 DTS packages and a couple DTS packages created in 2005 using the 2000 DTS.
Question is how to edit an existing DTS Package to view or alter the actual SQL script that was used to create the package. We need to alter the date range in the Where statement of the SQL script.
In SQL 2005, run SSMS -> Management -> Legacy -> Data Transformation Services. All the DTS Packages appear.
Right click on package and select "Open". The DTS 2000 Package Designer window opens and shows the package.
Right click on Create Table Results SQL Task -> Properties.
Shows SQL Script window with SQL script the creates the Results table, but this is a modified script - not the actual full SQL script with the Where statement!
We need to edit the actual SQL script for this package, not the Create Table script for the Results table.
BTW - this is a simple package that drops existing Results table then runs a SQL script to extract data to an Excel file.
See attached JPG
Can anyone point me in the right direction so I can edit the actual SQL Script?
Thanks.
August 7, 2009 at 7:56 am
You really are new to DTS...
Double click on the line between connection 1 and connection 2.. The first tab should have it.
CEWII
August 7, 2009 at 8:51 am
Elliot:
Thanks for the information. Yes this worked!
So simple but I could not find this even after looking for almost an hour.
Thanks again - you saved me a lot of grief
August 7, 2009 at 2:55 pm
You are welcome.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply