I've recently started using Sql Server SSIS packages and I'm having an issues importing more then one dbf file from a network drive into a sql table. I've followed all the directions for both of the links below yet I'm unable to use a variable name with a blank variable name as they state... to make it select all files. Here is a list what I need this package to do.
1.) Truncate the staging table in SQl Server 2008 - No issues
2.) foreach loop to pull data from 1+ dbf files(file names will never be the same...yet will always .dbf) and the data will be inserted into a staging table in sql sever 2008. Works fine with one .dbf file hard coded yet won't let me do multiple files.
3.) Once all .dbf files have been inserted into the table move all files (.dbf and .dbt) into a folder to be renamed and archived. Archived name will change the file to yyyymmdd.
Can someone help me do this dynamically....I've wasted a day trying trying to do this.