locked
Variable Mapping with Foreach loop container RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    By using select statement i extracted data from my oracle database and load into recordset desineation.

    Data types columns are org:varchar2, ID :Number, text1 varchar2, text2 varchar2.

    By using for each loop container i will try to mapping variable i got error like For each variable maaping can not be applied.

    Data type variable are ID:Double,org:char,text1:char, text2:char

    Thursday, March 14, 2013 4:29 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    Use a Data Conversion Transformation to convert all the varchar2 to char n (DT_STR, n,m).

    Arthur My Blog

    • Proposed as answer by Dinesh Menon Thursday, March 14, 2013 7:50 PM
    • Marked as answer by Eileen Zhao Thursday, March 21, 2013 7:45 AM
    Thursday, March 14, 2013 4:36 PM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    Use a Data Conversion Transformation to convert all the varchar2 to char n (DT_STR, n,m).

    Arthur My Blog

    • Proposed as answer by Dinesh Menon Thursday, March 14, 2013 7:50 PM
    • Marked as answer by Eileen Zhao Thursday, March 21, 2013 7:45 AM
    Thursday, March 14, 2013 4:36 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Before, writing to record set destination, use the data conversion task and change the data types as Arthur suggested.

    Thanks, hsbal

    Thursday, March 14, 2013 6:51 PM