sql server dts: what difference does it make if want to execute t-sql statements dritectly in the process task icon in the dts rather than creating a Stored procedure and executing it
in the process task icon

Posted via DevelopmentNow.com Groups

Hello sushnospam@developmentnow.com,

The differences are the exact same differences you will find when executing
a Stored Proc vs a piece of TSQL anywhere else. DTS is no different in the
ExecuteSQL task, it simply hands off to the connection underneath

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]