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 |
|
dhivya7
Starting Member
1 Post |
 Posted - 2012-06-07 : 09:04:51
|
| How to use execute sql task in ssis with variables??Sql statement : exec cal?,?Parameter mapping: user::table varchar user::include NumericI execute this queryError:[Execute SQL Task] Error: Executing the query "exec cal_extracttables?,?" failed with the following error: "Incorrect syntax near ','.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.How I sp with parameter used in ssis package. pls give me good article. I used variable and Result set also. But no use.I submitted tomorrow also.Pls help.regards,S.DhivyaDhivya |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-07 : 09:20:25
|
| I always use a variable which I set from an expression.Makes it easy to log what you are executing.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-06-07 : 11:52:30
|
| is there a space missing there?exec cal_extracttables?,?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
How to use execute sql task in ssis with parameter