Hi,

I need to know where can I edit the source code/script of a DTS package
saved on the sql server. It was not saved on a VB file or structured
storage file. I am running SQL 2000.

TIA.

If the package was save to msdb then your only choice of editing is through
designer. What is the reason you want to edit the package? If it is to
make things dynamic or change the next time it is run then have a look at
the dynamic properties task. There is also the /S switch on the DTSRun
commandline.

We have examples on www.SQLDTS.com of assigning values to properties of a
package.

--



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


<aamirghanchi (AT) yahoo (DOT) com> wrote