Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Preeti_Mumbai
Starting Member
4 Posts |
 Posted - 2011-11-29 : 09:27:33
|
how to pass connection string to ssis package.I am trying to run a package from C# code file, in that my requirement is such that I want to pass different connectionstring s enteres by the user through UI (dynamic access )so how it is possible to provide connectionstring dynamically.I am having a basic SSIS, which is simply copy data from one database table to other database table.I am having one table called "SERVER_CONFIG" in which i am storing Different SQL Server Database Credentials using one interface.Whenever SSIS package execute it will fetch information from “SERVER_CONFIG” table and then execute SSIS package (here I am passing SOURCE Database information)below is screenshot my "SERVER_CONFIG" table. [/url][/img]can any one help me regarding this |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
connection string to ssis package