Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anuj164
Starting Member
49 Posts |
 Posted - 2005-10-14 : 15:37:12
|
| I have a DTS package that uses an .ini file to define output file locations. I have the same path in about 20 lines. Is there a way in the .ini file to define the path as a variable and use the variable in the 20 lines it is used? This would allow me to customer define this path once for individual users/clients. Cheers.[global] OUTPUT_DATA_PATH="C:\Utility\DataWarehouseFeed\Tables\"OUTPUT_LOG_PATH="C:\Utility\DataWarehouseFeed\Logs\"COLUMN_DELIMITER=|[customer]FILE_NAME="Customer_Table.txt"COLUMN_NAMES="id,FirstName"NUMBER_OF_COLUMNS=2[account]FILE_NAME=Account_Table.txt |
|
|
|
|
|
Using an .ini file in dts pkgs