question

user-1440 (google) avatar image
user-1440 (google) asked

T-SQL script of SSIS task

Can I create a T-SQL script from an SSIS task(s)?

ssist-sql
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'm not sure I understand what you are asking. Do you want to be able to create a script using SSIS or do you want to script out an SSIS to T-SQL?
0 Likes 0 ·
I want to turn an SSIS task into a T-SQL statement, script out my tasks from a package. Isn't that possible?
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered

Sure, use the expression builder of a step and you can create a TSQL statement for use in that step or other steps.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Todd McDermid avatar image
Todd McDermid answered

No, this is not possible. The Tasks available in SSIS don't all have equivalents in T-SQL. The SSIS Tasks aren't equivalent to say, a table, such that you can go into SSMS and "right-click make a script" type of thing. SSIS is a very different, non-T-SQL based system.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.