Source Location From a Table. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Source Location From a Table.

All, I need your help in creating one SSIS package. Below is the Detail : 1. Copy the data from source to a destination table base of some condition (Straight Forward)
2. Move the files from Source location to Target Location ( this is the tricky part) · The Source Path is in given in the Table.
· Each file which needs to be move has a FILE_ID and one FILE_ID may have more than one file assosiated with it.
· Create a new folder on the destination with the FILE_ID number and Date Time.
· If one File_Id have more than one file, all the files should go the same folder. 3. Update the destination table Stats Columns after moving the files.. Please let me know that what is the best approch of doing this. Thanks in advance..Ar

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |