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.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Export Massive DTS to a structurated file storage

Author  Topic 

alejo46
Posting Yak Master

157 Posts

Posted - 2014-08-06 : 21:17:13
Good night, i need your help pls

i 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).aspx

and here: http://msdn.microsoft.com/en-ca/library/bb500440(v=sql.105).aspx#migrating_pkg
Go to Top of Page

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]
Go to Top of Page
   

- Advertisement -