Feeds:
Posts
Comments

Archive for November, 2011

This is because the content of the column may have contained hard spaces such as tab etc.. instead of soft space..

Use the following code to make it work:

RTRIM

(LTRIM(REPLACE(REPLACE(REPLACE(column_name,CHAR(9),‘ ‘),CHAR(10),‘ ‘),CHAR(13),‘ ‘

)))

 

Read Full Post »

To fix – http://sqlclick.com/index.php?option=com_content&view=article&id=56:ssis-error-a-rowset-based-on-the-sql-command-was-not-returned-by-the-ole-db-provider&catid=41:ssis

When building SSIS packages, a common error is:

 A rowset based on the SQL command was not returned by the OLE DB provider.

This can occur when using a stored procedure, with multiple query calls, as your OLEDB Source Command. What we have found is that adding the following line at the top of your stored procedure will get rid of this message:

SET NOCOUNT ON;

SET FMTONLY OFF;

Read Full Post »

%d bloggers like this: