Viewing 5 posts - 1 through 5 (of 5 total)
Now I ahve encounter another problem. My DTS pack is working fine. But now it is not loading proper data.
eg my csv file contains 108 ...
May 7, 2009 at 12:56 pm
Thanks for your reply. But i am new to this DTS programming. Also I ahve little knowledge about VB script
' Copy each source column to the destination column
Function Main()
Main...
May 4, 2009 at 2:19 pm
I am getting following error:
The number of failing rows exceeds the maximum specified:
Transformcopy'DTSTransformation_95'conversion error:Conversion invalid for datatypes on column pair1(source column'Col095'(DBTYPE_STR), destination column'createDate'(DBTYPE_DBTIMESTAMP)).
May 4, 2009 at 11:39 am
I just confirmed thius file is automatically generated from prog and will proper date field or nothing which is blank field
May 4, 2009 at 7:32 am
Yes it is 0 in sample data. Sometimes it is an empty field e.g 123456,,0,12/04/09etc
May 4, 2009 at 7:19 am
Viewing 5 posts - 1 through 5 (of 5 total)