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  Development Tools  ASP.NET  Setting expression on connection manager in C#?

Author  Topic  psg Starting Member 3 Posts Posted - 2010-05-17 : 11:01:23 Greetings, I'm developing a C# application to generate SSIS packages from code. Some of the packages read flat files and transfer the data to an OLEDB connection. The flat files are accessed via a connection manager. Right now I'm trying to pass a variable as an expression to the connection manager, but I can't figure out how to set the expressions on the file manager. Does anybody know how to do this? In the .dtsx-package, the relevant section looks like this: <DTS:PropertyExpression DTS:Name="ConnectionString">Expression</DTS:PropertyExpression> TIA, Jan