I would like to be able to specify the path and file name to a flat file source connection at run time from a VB.NET windows application which will then run the SSIS package.

I can open a common dialog box in VB and have the user select a text file to load. How do I pass this file path in to the SSIS package connection manager so it will be available to the flat file source in the Data Flow configuration?

I have a package running with a path and file name specified in the ConnectionString property. My question is how to change that property at or just before runtime.

Larry

First you must create a package configuration (SSIS->PackageConfiguration -> add)
In the dialog box choose XML configuration, insert a name for destinatio n file, next.
Now, in the object list, you can choose all value do you want change at runtime, so you can go in connection and find your configuration manager.
select wich property do you want read at runtime.
save the package configuration

Now, with vb you can modify the file xml

by

abc