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 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy