Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2014-01-17 : 16:14:20
|
| I would like to know how to execute straight t-sql in sql server 2012 from ssis manager that passes 3 parameters to the sql listed below:Baiscally the sql looks like the following:Select * from customer_tablewhere customer_name = @custname and customer_number = @custnumber and customer_state = @custstate. @custname is varchar(30), @custnumber is varchar(10), and @custstate is varchar(02)Thus can show me the sql that will run the sql listed above? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-18 : 04:29:41
|
if you're asking about how to use this in execute sql task then use code asPosted - 01/17/2014 : 16:14:20 Show Profile Email Poster Reply with Quote Nuke Spam!I would like to know how to execute straight t-sql in sql server 2012 from ssis manager that passes 3 parameters to the sql listed below:Baiscally the sql looks like the following:Select * from customer_tablewhere customer_name = ? and customer_number = ? and customer_state = ? and map parameters in parameter tab------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
t-sql 2012 with parameters