Ask a Question
Advertise on boostr.in
Organizational Research By
Surprising Reserch Topic
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.
Related Hot Questions
Government Jobs Opening