August 11, 2009 at 9:44 pm
How to Schedule a migrated DTS(from Sql 2000) in SQL Server 2005 without converting to SSIS Package?
August 12, 2009 at 3:32 am
According to me this is not possible. When you add any new step in the job then it asks for SSIS package and its location. There is no option of DTS package there.
-LK
August 12, 2009 at 10:27 am
Well, there was no DTS package option in SQL 2000 jobs either. You run DTS packages in CmdExec steps just like in SQL 2000.
Create a new SQL Agent job and add a step with Type = "Operating system (CmdExec)" and put the DTSRUN command in the Command window.
If you have a job that runs the package in SQL 2000, you can script the job in Enterprise Manager and run the script to create the job in SQL 2005.
Greg
August 12, 2009 at 1:00 pm
Hi Kuldeep,
Greg is right!
Best Regards,
SQLBuddy
August 15, 2009 at 8:41 am
Hi Kuldeep,
If you want to execute DTS Packages in SQL Server 2005 as a DTS Package only, you can download and install DTS Designer, its a utility given by Microsoft.
It also helps when you want SSMS to connect to a SQL 2000 instance and execute DTS Package without a Job, after installing this utility you'll be able to view and execute the DTS Packages under the head of Management - Legacy-Data Transformation Services.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
August 16, 2009 at 8:37 pm
Sarab (8/15/2009)
Hi Kuldeep,If you want to execute DTS Packages in SQL Server 2005 as a DTS Package only, you can download and install DTS Designer, its a utility given by Microsoft.
It also helps when you want SSMS to connect to a SQL 2000 instance and execute DTS Package without a Job, after installing this utility you'll be able to view and execute the DTS Packages under the head of Management - Legacy-Data Transformation Services.
For clarification, as Greg explained, DTSRUN is still available for scheduling or ad-hoc execution of a DTS package from a CMD prompt in a SQL 2005 environment, and either will work without any additional downloads.
The DTS designer download would be something you'd install on your development machine with which to modify or debug a DTS package. It doesn't have any business (that I can think of) on your production db server.
August 16, 2009 at 9:03 pm
Obviously, i don't think that someone will install Client tools on the Production Server. That too just to Execute something. 🙂
DBA's work remotely all the time until and unless theres a special constraint.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply