February 2, 2010 at 6:46 am
Hi,
I am trying to move data from a table on my source database, to an exact replica table on a new destination database. One particular column keeps causing the whole package to fall over. In the source it is datatype char(9) as well as in the destination. But for some unknown reason, SSIS is picking it up as an unsigned int (DT_I4). I cannot even convert this column to (DT_STR) within the package as I'm not given the chance - the package fails almost instantly when trying to 'read' the source that is char, that it sees as int. :crazy:
I've done several hundred packages, all very similar and all work except for this one.
Any suggestions as to how I can get around this problem or what might be causing this would be great?
Has anyone encountered something like this before?
Thanks,
Jinx.
February 2, 2010 at 7:12 am
Problem solved - had to recreate the entire package with all new connections. that seems to have 'cleared' the problem.
February 8, 2010 at 6:03 am
February 9, 2010 at 12:44 am
Good point! That would probably have sorted out the problem. It doesn't help when you are an SSIS noob like me ;-).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply