Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Using dynamic INI files for DynamicPropertiesTask

Status
Not open for further replies.

Cafeinomane

Programmer
Apr 9, 2002
11
CA

Hi there,

I'm new to SQL 2000 I am a programmer, not a DBA. I'm the first here to use DTS as I need to transfer data between MSSQL and Sybase.

The basic goes well... But when I try to remove hardcoded properties, like for ODBC connections, I need to pass an INI file to the package. I used a global variable and the /A at calling time, no problems... But HOW THE HE** do I change a DynamicPropertiesTask to use the global variable as the path and filename of the INI file to use instead of its hardcoded value???? I've tried real hard with ActiveX and can't get anything workin'.

Help please, I'm at a lost and been working on that all day!

Thanx!

Cafeinomane
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top