February 19, 2010 at 11:41 pm
hi i am using VS 2005 to develop a SSIS package. The package picks up all csv files in a folder and loads them to table . the csv files are later renamed as .csvimported.
i have placed *.csv as file spec in the for each loop container. however the issue is the container picks up all file with .csv and .csvimported extension. could you please help me sort this issue.
I am upsizing the package from dts to SSIS and the dts has been running for many years now. Hence the folder will have thousands of files with .csvimported extension. hence it is very important for me to select only .csv files.
February 20, 2010 at 1:18 am
Not sure about that 'bug', but why not simply move the processed files to another folder (/Archive, for example)? It's tidier and your problem will go away.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply