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 |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2014-08-06 : 21:17:13
|
| Good night, i need your help plsi know the DTS package were in older sql server vesrtions and slqver 2008 support ssis but initially in a Production server there was an upgrade from ss2000 to ss2008.The problem is i was asked to export a masive DTS to a file, i know how to do it manually to a structured file storage. Is there any way to export massive DTS packages because there are about 100 DTS ?I really appreciate your help in advanced |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-07 : 08:09:00
|
| see here: http://msdn.microsoft.com/en-ca/library/bb500440(v=sql.105).aspxand here: http://msdn.microsoft.com/en-ca/library/bb500440(v=sql.105).aspx#migrating_pkg |
 |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2014-08-07 : 14:16:42
|
| Not sure if this is what is required, below link uses SQL script and batch file to extract DTS from msdb.[url]http://stackoverflow.com/questions/16309263/script-to-export-all-dts-packages-on-is-to-file-system[/url] |
|
|
|
|
|
|
Export Massive DTS to a structurated file storage