September 19, 2005 at 4:30 am
Hi
I have created a dts package which has to import a csv file into a sql table.
That table has an identity column which can not be imported and thus has to be filled doing the import.
Now I have seen you can check the Enable indentity insert chceckbox but it doesn't work either. It increeds with 1.
How can I resolve this ?
Thx in advance.
JV
September 19, 2005 at 6:41 am
What's not working exactly??
September 19, 2005 at 7:10 am
The number of failing rows exceeds the maximum specified.
Conersion error. Destination overflowed on column pair 1.
Source column Coll001, destinationcolumn fld_ru_pt_id
Which is very strange because this isn't a link in the transformation.
fld_ru_pt_id is the identifier.
JV
September 19, 2005 at 7:15 am
Already solved it.
Thx.
JV
September 19, 2005 at 7:17 am
What's the solution??
September 19, 2005 at 7:26 am
I've killed the translation between source and destination and created it manually.
That did it.
JV
September 19, 2005 at 7:27 am
can we some some before/after picture??
September 26, 2005 at 2:12 pm
hi,
thanx for making DTS,
can u send me this DTS package
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply