What is the best way to save a DTS Package. I don't seem to be able to
modify any of the different types, such as if you save it as a "SQL Server",
how do you modify it?

Then I saved it as a SQL file, a dts file, but now how do I open it so I can
modify it?

I would really like to save the dts package as a sql script, then I can
modify it, is there a way to do that?

Thanks for your help for this sql dts beginner.

When you save a package to sql server you can find it on the server to which
you saved it and then look in

Data Transformation Services | Local Packages

When save to a structured storgae file

Right click on Data transformation Services folder in EM and choose Open
File.


There is from within the Designer a way to save a package out as a VB .bas
file



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"et" <eagletender2001 (AT) yahoo (DOT) com> wrote

Hi et,

"et" wrote:
The DTS has nothing to do with SQL directly. This is a extension based on
vb code, giving you much more possibilities than T-SQL alone.
If you want to modify it as "Text" you only can save it as VB code and edit
the source code.
To store it in a SQL Server again you have to execute it and activate the
"goPackage.SaveToSQLServer" line.

As a dts file, you only can open and edit the package in the designer.

HTH
Helge