I have a DTS Task that has the following:

* Dynamic Property
* SQL Task (Truncate a table in SQL)
* Connection1 (Input CSV file)
* Connection2 (Output SQL Server)

This tasks previously did not contain a Dynamic Property and, as you know,
the connection details and filename was hardcoded.

To remove the hardcoded values, I created a DTS.INI file that has
"Servername", "Username", "Password', and "Database" names, etc. under a
[DTS] section heading.

The Dynamic Property reads the DTS.INI file to obtain its values.

I have a SETUP program that will dynamically create the DTS.INI file at
installation and will install the DTS package within SQL Server.

My only opportunity now with the package is that the SQL Tasks has the
hardcoded name and SQL statement that includes the database name. Does
anyone know of an easy way to change this information?

Can I also use an INI file for this?

Any help would be appreciated.

Hi,

dm4714 wrote:
Then use an activeX task to replace placeholders in the sql statements with this database name.

Helge

In message <3ev5rkF54db3U1 (AT) individual (DOT) net>, Helge C. Rutz
<news050424 (AT) nurfuerspam (DOT) de> writes

This may help-

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I would also take a look at the best practice document put out by
Trey Johnson and Mark Chaffin
http://msdn.microsoft.com/library/de...tbpwithdts.asp
This document was written for SQL Server 2K. I'm sure there will be a new
doc when Yukon is released with Integration Services.

"dm4714" wrote: