Ask a Question
Advertise on boostr.in
Question:Que.Why does the Execute SQL Task fail while using two parameters?
I am using SQL server Data Tools (SSDT) 2010. I am getting following error in an Execute SQL Task:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value,
if available. No work was done
The SQL Statement is set to:
INSERT INTO DerivedSoftware
¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†(Name, VendorID, RuleID, GroupID, SourceEnumID, DeviceID)
¬†¬†¬†¬†VALUES ('?', '1', '1', '1', '1', ?)
The parameters being used are of data types String and Int32.
If I edit the Execute SQL Task so that it only uses one of these parameters, it works fine. Either one works fine. But attempting to use both fails with above error.
Manually running similar commands in SQL Server Management Studio works fine.
Anyone know why?
Sep 13, 2013
Java Interview Questions
Sep 12, 2013
to add a comment.
Your name to display (optional):
Email me at this address if my answer is selected or commented on:
Email me if my answer is selected or commented on
Privacy: Your email address will only be used for sending these notifications.
To avoid this verification in future, please