October 31, 2005 at 1:53 pm
I have created multiple DTS packages that are called using dtsRun and Global variables for different regions (region (1 to 1) with System DSN).
Moving from dev to model a File DSN is required versus a System DSN. I am looking for the property/s to set the global variable for the file DSN.
currently: DataSource: gv_target_dsn
All assistance appreciated.
Daryl
October 31, 2005 at 2:47 pm
While testing/digging into...
dynamic properties Task:
Connections
ODBC Connection (name)
OLE DB Properties
Extended Properties
.. attach a global variable to this value gv_file_dsn
.. the value to add to this comes from the characteristics from the file dsn.
aka Driver=Attunity Connect Driver; bindurl=1.1.1.1:1515:fixedNAT;defTdpName=Region_1;
This value (psuedo connectstring) can be passed to the DSN in the global variable allowing one dts package to work for multiple regions.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply