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 |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2008-02-22 : 09:35:47
|
| Hi when i migrate a DTS to a SSIS server are the stored procedures that the DTS calls migrated with it ? |
|
|
talleyrand
Starting Member
35 Posts |
Posted - 2008-02-22 : 10:12:43
|
| That depends entirely on what your migration entails.DTS and SSIS are ETL applicationish items, they can't be seperated from the database and executed on their own but they're not really part of the RDBMS. The stored procedures that your DTS package called, those are bound to a particular database so if that database goes somewhere, the procs go with.So, if you have an instance of SQL Server 2000 on box A, database named LEGACY and you've migrated LEGACY to a SQL Server 2005 box B, then your stored procedures, udfs, triggers, tables, etc should have gone with it. Unless of course the migration was done via "Export Data" and then of course you'd only have your data on the new instance.If you upgraded your 2000 to 2005 in place, then I can't see any reason why the stored procedures wouldn't be there. |
 |
|
|
|
|
|
DTS - SSIS