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?
Using SSIS to integrate generated insert scripts in .SQL format????
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.
- Proposed as answer by Katherine XiongMicrosoft contingent staff, Moderator 54 minutes ago
Free Windows Admin Tool Kit Click here and download it now
September 13th, 2015 8:17pm