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.