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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Dynamic connection from asp.net

Author  Topic 

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2011-10-02 : 06:20:26
Hi,

I have a SSIS package with an Excel file and DB connections. I have a source , data conversion task and ole db destination that inserts records into the db.

How can I send dynamic connection strings to the package from the website and how do i set dynamic connections in the package itself?

Thanks

paultech
Yak Posting Veteran

79 Posts

Posted - 2011-10-02 : 07:19:16
hi ,

may be the following link is useful for what you want:

http://www.eggheadcafe.com/tutorials/aspnet/a8e96109-dc79-404d-b1c4-c2bcb1f4ff48/making-ssis-package-to-accept-dynamic-oledb-connetions.aspx

Go to Top of Page
   

- Advertisement -