Using SSIS to integrate generated insert scripts in .SQL format????

I generated several table insert scripts from another database in different .SQL files in the same folder.   What is a good way to transfer the insert scripts using SSIS to a SQL SERVER database from the folder they are located in?

September 13th, 2015 7:03pm

TO transfer the files you no need SSIS package. YOu can copy the files. and open in SSMS and execute manually.

To automate you can use a use a for each loop container and read each file and execute. as a t-sql script.

Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 8:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics