sql server dts: script/code for a DTS package -- sql server dts

script/code for a DTS package

aamirghanchi NO[at]SPAM yahoo.com
6/17/2005 4:42:25 PM

sql server dts: 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.

Re: script/code for a DTS package

Allan Mitchell
6/18/2005 11:51:12 AM

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

[quoted text, click to view]