I have 2 packages: Package A reads all the files in a folder
Package B has a text file source connection, a SQL server connection and a task that will import the contents of the text file source into a table in the SQL Server connection

The purpose of package A is to read all the files in a folder loop through all the file names in the files collection and Load package B and pass to Package B the files to import.

I have Package A working to the point, I can not figure out how to dynamically change the file to process in the Package B Text File source.

any suggestions?

Hey,

You could try to use a Dynamic Step task, and execute package B using a stored procedure (using xp_cmdShell and dtsrun, and pass in the file path as a property) or through code. You will probably have to kick off package B once for each file in the folder.

Brian