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)
 parameters

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-06-18 : 04:57:13
how can i use parameters in ole db source or other source connection in ssis?

thanks

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2009-06-18 : 11:54:31
You mean you want the data source to be changed during runtime?

You can create a new variable to hold the data source and use it in the "Expressions" in the OLE DB data source.

This variable can be a configurable property at runtime.

Check out about using the "Expressions" ..it should take care of your cause.
Go to Top of Page
   

- Advertisement -