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 |
|
tymemynt
Starting Member
2 Posts |
 Posted - 2008-04-23 : 11:44:41
|
| i'm migrating my dbase from SQL 2000 to SQL 2005..i've restore the dbase to SQL 2005..but what about the SQL job?..do i need to create them back in SQL 2005?..how to do that?..1 more question..how to migrate DTS from SQL 2000 to SQL 2005?..i've ActiveX script in my DTS...really need help from all of u..thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-23 : 13:39:31
|
| 1) you can use Transfer job task in SSIS to migrate jobs.2)Use DTS migration wizard to migrate DTS to SSIS . Activexscript with COM object are not supported in SSIS. you have to use script task for it. |
 |
|
|
|
|
|
need help to migrate DTS from SQL 2000 to 2005