Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Simple SQL query works in SQL server, but not in SSIS Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 2:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:32 PM
Points: 182, Visits: 479
IF(0 > 0 OR 0 > 0 )
BEGIN
PRINT 'OKAY'
END

That is my simple query. In SSIS it causes an error -

[Execute SQL Task] Error: Executing the query "IF(0 > 0 OR 0 > 0 ) BEGIN
PRINT 'OKAY' END" failed with the following error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.


How do I fix this ?


Post #1514853
Posted Friday, November 15, 2013 11:40 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:25 AM
Points: 4,828, Visits: 11,184
Try using SELECT instead of PRINT.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1514892
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse