Organizational Research By

Surprising Reserch Topic 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

Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.