SSIS 2008 Variable Data Type Mapping/Conversion Problem

• Craigmeister

  Ten Centuries

  Points: 1135

  More actions

  November 4, 2013 at 11:59 am

  #282071

  Greetings,

  I am using SSIS 2008 to try and get the results of a Sybase stored procedure into a SQL Server 2008 table.

  Current Configuration:

  The Sybase connection is via Sybase OLEDB Provider. An ExecuteSQL task runs the stored procedure and the results populate a variable of data type - object. A For Each Loop container maps the returned data's columns into corresponding variables and populates the variables. An ExecuteSQL task inserts the values from the variables into a table.

  Problem:

  The result columns with data type varchar and date are populating the corresponding variables with data types String and DateTime. The issue is that result columns with data type numeric and decimal are producing an error during the For Each Loop variable population.

  Error: 0xC001C012 at Process For Each Symbol Record: ForEach Variable Mapping number 4 to variable "User::<variable name>" cannot be applied.

  I have tried setting the data type for the problem variables in question to Single,Double, Int32, Int64 with the same results.

  Question:

  What is the correct data type to allow the For Each Loop container to populate the variables with the values?

  Note:

  I am using this method because using the stored procedure as a source in a dataflow task is also problematic. Executing via debug mode from my machine and the server this will run on crashes the execution, actually creating dump files. I am also trying to avoid the "macro" step of having to use an interim csv file.

  Thanks in advance for your help.