Can I create a T-SQL script from an SSIS task(s)?
asked
T-SQL script of SSIS task
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?
I want to turn an SSIS task into a T-SQL statement, script out my tasks from a package. Isn't that possible?
Sure, use the expression builder of a step and you can create a TSQL statement for use in that step or other steps.
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.
