Hi,
I am calling DTS package using C# in my current application on dev server.
The DTS package tranfers file from Excel to SQL Server table.
When i migrated the package from dev server to production server, i had
forgotten to change the server name in DTS package.
Is there any way i can pass the connection string to DTS package through C#
code, which will prevent rechecking the server name, when migrated from dev
to production server in future.