sql server - Running SSIS package for different databases on selection of a drop down on a windows form -
i have made ssis package transfer data between 2 databases on different server. issue unable pass connection string in package dynamically @ run time. have windows form execute package. on windows form have drop downs select source , destination databases transfer data. can have way tell package connection string of source , destination database needs perform actions @ running time, dynamically on click of windows form drop down clicks..
if destination server not change each time can concatenate server name in ssis package connection string variable, if not need pass server name form windows form.
Comments
Post a Comment