sql server dts: Through the log file ?

Are you using SQL Server 2000? If yes then you can use the dynamic
Properties task to do this quite easily. You can also use Global Variables
in your package and assign them to properties. You can set these values
when you call the package through DTSRUN by altering the /A switch value.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


[quoted text, click to view]
Hi All

Iam using the DTS to transfer the tables from Sybase to Sql Server. It is
Running fine. But i have wnat to pass the connection to sybase and Sql
through the log. Because i don't want ot hardcode the connections . Plz any
body help me in passing the connection through the log file to DTS package.

Thanks in advance

Vasu

Hi All

Iam using the DTS to transfer the tables from Sybase to Sql Server. =
It is Running fine. But i have wnat to pass the connection to sybase =
and Sql through the log. Because i don't want ot hardcode the =
connections . Plz any body help me in passing the connection through the =
log file to DTS package.

Thanks in advance