CODEWITHSUNDEEP
sql-serverbatch-filessis
sequel.learner
sequel.learner

Reputation: 3941

How to convert SQL to SSIS task?

I execute a couple of SQL queries using a batch file. I want to execute all this SQL using SSIS also. Can someone suggest how I can do that?

Upvotes: 1

Views: 131

Answers (2)

twoleggedhorse
twoleggedhorse

Reputation: 5048

Here is a link to the basics of creating SSIS packages, I went to google and typed 'ssis for beginners':

http://www.codeproject.com/Articles/155829/SQL-Server-Integration-Services-SSIS-Part-1-Basics

You'll probably want to use one or more 'Execute SQL Task's. A guide to these can be found at:

http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx

You will probably want to use

ConnectionType: OLE DB (or ADO.net)
Connection: Click here to setup a connection manager (should be a button towards the right of the text box)
ResultSet: Single Row
SQLSourceType: direct input
SQLStatement: You SQL command goes here

Don't worry too much about the other settings for now.

Upvotes: 1

Anoop Verma
Anoop Verma

Reputation: 1505

This is a wide open question. You can simply create a connection string and call the individual sqls or the stored procedure and be done with it. But that should not be the goal.

One advantage that an SSIS solution provides over the SQL statements that the task can be broken into smaller steps thus rendering your solution more structure and maintainability.

Upvotes: 0

Related Questions