CODEWITHSUNDEEP
sqlsql-serverssis
Haidar
Haidar

Reputation: 176

How to process multiple SQL files using SSIS package?

I have number of .sql files which I need to execute them in particular order. How can I do this using SSIS package?

Otherwise, I have to execute these scripts manually in sequence.

Upvotes: 0

Views: 596

Answers (1)

SQL.injection
SQL.injection

Reputation: 2647

SSIS have a component that is "execute SQL Task". Make a flow of "execute SQL Task" and voila you have your scripts executed by the right order.

Upvotes: 2

Related Questions