Organizational Research By

Surprising Reserch Topic

boostr.in questions - 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?
asked Sep 13, 2013 in Java Interview Questions by anonymous
edited Sep 12, 2013
0 votes
25 views



Related Hot Questions



Government Jobs Opening


...