Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kentzhou
Starting Member
4 Posts |
 Posted - 2009-05-01 : 11:11:43
|
| I migrate sql server 2000 to sql server 2008. There are many DTS package is scheduled on SQL Server 2000 as jobs under sql server agent.then I move all those databases and DTS Packages to new instance of sql server 2008. Then I try to schedule all DTS package as jobs that would be runing at night as routine.In SQL Server 2000 enterprise manager, I can click on any DTS Package --> Schedule Package... to create a job under sql server agent. but there is no such Menu in Microsoft SQL Server Management Studio for sql server 2008 any more.How to create job to schedule those legacy DTS package in SQL server 2008 before they are migrated to SSIS? |
|
|
jmill130
Starting Member
26 Posts |
Posted - 2009-05-20 : 11:00:47
|
| All you should need to do is create a new job on the sql08 server and have it run this code: Type in the sjob step would be : Operating System (cmdexec)dtsrun /S yoursqlserver08namehere/E /N nameofthemigratedDTSpackagehereWhat i did was i exported the DTS package from sql2000 to a .DTS file then imported into sql08. When you import into sql08 it should reside in a folder under SSMS here: Management->Legacy->Data Transformation ServicesI have successfully done this with no problems. If you have problems, let me know, i can send you some screen shots. |
 |
|
|
rr1980
Starting Member
1 Post |
Posted - 2010-12-01 : 01:26:21
|
| Hi,I know this is a bit late, but if you still look at this, I am having the same problem. I ran the command that jmill130 specified and am still getting an error-"The process could not be created for step 1 of job 0x3CE5106CB1AB784180DB2911CA2F8B22 (reason: 2). The step failed.,00:00:00,0,0,,,,0" WOuld you be kind enough to send me a couple of screenshots.Thanks in advance |
|
|
|
|
|
|
|
|
How to schedule legacy DTS in sql server 2008?