SSIS type mismatch issue with SQL SERVER 2005 stored procedures output parameters

MSDN recognize as a SSIS bug that a bigint output parameter returned by a sql stored procedure cannot be assigned to a Long SSIS variable . A way to solve this is to get the output param as a VARCHAR, and then, in an Script Task, convert the varchar variable to a one that has the type LONG.

I encountered the same issue with a datetime variable, but that may be because Visual Studio is English and Sql Server is French. To solve that issue :

DECLARE outputDate as varchar(30)

SELECT outputDate = CONVERT (VARCHAR,dateTimeFiels, 120) FROM… .

In SSIS , the output varchar variable will be converted at the next step to a DATE type variable.

Advertisements

Tags:

2 Responses to “SSIS type mismatch issue with SQL SERVER 2005 stored procedures output parameters”

  1. cricotanierea Says:

    Very good !

  2. SSIS – SQL task and Script Component « thulasirangan Says:

    […] output parameter returned by a sql stored procedure cannot be assigned to a Long SSIS variable .” https://cschiopu.wordpress.com/2007/10/26/ssis-issue-with-sql-server-2005-stored-procedures-output-pa… Webservice task: The below link has a document explaining the usage of webservice task in a clear […]

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: