Home Forums Data Warehousing Integration Services Input File name to SSIS package: RE: Input File name to SSIS package:
Ted Zatopek Old
Ten Centuries
Points: 1299
More actions
December 21, 2009 at 1:09 pm
#1095050
The two ways we've done this are:
1) Writing the filenames as the contents of another file that you use as a source in the SSIS package.
2) Writing the filenames to a SQL table that you use as a source in the SSIS package.
...hope this helps