Can an SQL script be generated for a DTS package? I need to be able to
create script to recreate every object that relates to the normal
functioning of the database. Most other objects are easy to get an
executable script to recreate. I can't seem to figure this one out.
Thank you,
JulianDTS packages can include non-SQL structures like VBscripts etc. So the only
ways, you can save them as structured storage file, VB file, Metadata
Service or as binary data in MSDB database. Each of the options can be found
in SQL Server Books Online under the topic "saving DTS packages"
Anith
No comments:
Post a Comment