Hi,

I have used the DTS Wizard to generate a DTS script
that migrates table data from a Sybase DB to SQL Server.

I now want to be able to plug in the DTS Dynamic
properties such that I can change both the Source and
Target databases.

I'm hoping I do not have to edit the original tasks
that were generated by the DTS Wizard and that I can just
"plug-in" the dynamic propeties tasks.

s thi1s possible. I have Saved by DTS package within
SQL Server and will be executing it from this environment.

Thanks

The Dynam' Prop' task is useful when reading from a source so a Query or an
INI file things like that.

Personally I would have an Active Script task at the start of the package
which did the assignments

conn.Catalog = DTSGlobalVariables("ThisCatalog").Value


When i call the package I would use DTSRUN and use the /A switch.

How are you calling this?


--



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


"Greg Cook" <greg_cook (AT) transcanada (DOT) com> wrote