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