I need to create and SSIS package in SQL Server 2008 R2for an EDI project . The package needs to import data from one or more .csv file(s) into a table in a SQL Server 2008 R2 database.
The files are need to be retrieved from the following path: \\EDIFiles\SFTP\TARGET .
The .csv files have 20 columns, but only 5 on those columns need to be imported into the SalesOrder table.
Once each file is processed, it needs to be archived in the following folder: \\EDIFiles\SFTP\TARGET\Archive.
How do I do this? Thank you very much in advance,