The following comments are owned by whomever posted them. This site is not responsible for what they say.
SSIS Execute SQL Task Editor
Authored by: Julian Kuiters on Friday, May 12 2006 @ 08:08 AM AEST

You'll want use a sql statement like:

exec dbo.dbm_DropAllTableConstraints ?, ?

then in the Parameter Mappings for the Execute SQL Task you will need to add your two parameters. Use the drop downs to select the Variable Name that holds your parameter values. Set the parameter name to 0 (zero) for your first parameter, 1 (one) for the second.

You wont need an expression then to use a parameterised SQL Statement with the Execute SQL Task.

[ # ]


Gold Coast Aquarium Maintenance | Gold Coast Marine Fish | Gold Coast Tropical Fish
Jewel Jones - Counselling Service - Penrith, Richmond
 
     
 Copyright © 2017 Julian Kuiters
 All trademarks and copyrights on this page are owned by their respective owners.