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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-04-10 : 15:45:17
|
| How to schedule a DTS package residing in LEGACY container, from SQL2K5? ------------------------I think, therefore I am - Rene Descartes |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 15:52:23
|
| Schedule in SQL 2000.You should be able to see in SQL 2005 interface. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-10 : 15:56:17
|
quote:
Originally posted by sodeep
Schedule in SQL 2000.You should be able to see in SQL 2005 interface.
Can you be more specific? Do I need to install SQL2K client tools e.g. EM?------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-10 : 22:49:47
|
| That will not work. But you can migrate dts packages to ssis. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-10 : 23:27:23
|
| There is DTS 2000 execute task in SSIS package .That can help if you don't want to migrate. Not sure it will work. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-04-11 : 08:56:07
|
quote:
Originally posted by sodeepThere is DTS 2000 execute task in SSIS package....
Hm...ok, I will try this. Thanks------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
DTS scheduling in SQL2K5.