Importing records from a text file to a SQL table. Text file name changes daily
Posted on 2011-05-11
I would like to create a SSIS package in SQL Server 2005 that will read records from a text file in a specified folder. This will insert all records from that text file into a table.
The problem is that the name of the text file willl change daily. The only part of the name that will not change is the first 6 characters. If I could call it by using something like cusers*.txt it would help.
I know how to generate a SSIS package using the import data wizard and choosing a flat data source, but I am not that familiar with tweaking the SSIS package to use a wildcard in the name.