Wednesday, March 7, 2012

How ? Global variable as SQL Connection in DTS

Can I define a Global variable and use it as a Connection to SQL Server .

What I want to do is Create a DTS which pumps out files to an app server. However this might be done in different environments and I want to keep the SQL Connection Dynamic and change it in global parameter value.

Please help ,,,

ThanksI would write a sproc with bcp...and keep the configurations in a table...

Does it have to be DTS?

No comments:

Post a Comment