Wednesday, March 21, 2012

Export & import DTS Packages

Hello,

I have a problem with exporting and importing a DTS package from one
server to an other.
Saving a package like a VB-file is an option I have seen, but how can I
import a VB-file on the new server. Do I need a separate program?
Is there a possibility like exporting and importing a Job (Create SQL
script and run it in the Query analyser)?

Thanks,

Hans

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!How about using our utility

Transferring DTS Packages
(http://www.sqldts.com/Default.aspx?204)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Hans de Korte" <hans.de.korte@.prominent.nl> wrote in message
news:4097b18e$0$206$75868355@.news.frii.net...
> Hello,
> I have a problem with exporting and importing a DTS package from one
> server to an other.
> Saving a package like a VB-file is an option I have seen, but how can I
> import a VB-file on the new server. Do I need a separate program?
> Is there a possibility like exporting and importing a Job (Create SQL
> script and run it in the Query analyser)?
> Thanks,
> Hans
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks, it's succeeded

Hans

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!sql

No comments:

Post a Comment