Post reply

Epex data extraction, varchar is not working

  • June 24, 2010 at 9:36 am

    #139485

    I got stuck with SSIS. I used the datareader source to extract Epex data (ODBC provider) and migarant to SQL server 2005. It works fine with integer, datetime and boolean , but not varchar, note. once there is any varchar involved the datareader turns yellow forever and nothing returns.

    has anyone got the idea about these? thanks

  • July 7, 2010 at 6:24 am

    #1189560

    Have you had any luck with this? We get the same here. However the packages work once they're deployed on the server, so it may be related to the O/S. Our workstations are XP. What are you running?

    Chris

    .

  • July 8, 2010 at 9:40 am

    #1190336

    Have you tried within your SELECT statement to CAST/CONVERT the variable length VARCHAR fields to a fixed length data type, e.g., CHAR.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply