Thursday, May 10, 2012 12:16 PM
I am facing DTS package extractor data loading issue in SSIS (2008) when i run job. Data is mapped in flat text file as per table columns but its not inserting data as per column mapping. Like as
Look Marial_Status column is showing junk value. Correct value in createdate column an so on.
Thursday, May 10, 2012 1:25 PMModerator
Looks like the file either not in the correct/expected format - a | delimiter lurked in or the metadata settings are skewing the load. Check, and check.
Arthur My Blog
Thursday, May 10, 2012 1:45 PM
Look data i beleive its in correct form....
0001|PLS|PKR|0568617651002295|NAYAB|07-OCT-2011||A||NAYAB HOUSE# E/5 NEAR JACKSON PS KEAMARI KARACHI PH: 0301-3366648|GSL|SG||41203-6402545-6||UMRAH KHATOON|08-MAR-1986|F|M|17-OCT-2011|056861765|||||Y|
0001|PLS|PKR|0569442121002303|SYED MUHAMMAD OBAIDUL ARFIN (SATFF)|13-OCT-2011||N||SYED MUHAMMAD OBAIDUL ARFIN B-220 BLOCK-C NORTH NAZIMABAD,KARACHI. PH:03323080860|IND|SG||42101-7565839-7||REHANA|17-DEC-1985|M|S|17-OCT-2011|056944212|||||Y|
Thursday, May 10, 2012 2:19 PMModeratorThen the mapping is not
Arthur My Blog
Thursday, May 10, 2012 2:33 PMThe cause of the Y| in your marital status field is the extra | that you are getting at the end of your rows. Define one additional dummy column in your source definition to take that delimiter out. Your other issue appears to be in your mapping of the columns to the destination.
- Edited by Chuck Pedretti Thursday, May 10, 2012 2:34 PM
Thursday, May 10, 2012 6:11 PMnoooo..data format is correct if i execute DTS package then its work fine...but through SSIS its creating issue....plz suggest anything more !!!
Friday, May 11, 2012 1:04 PMany idea?
Friday, May 11, 2012 1:27 PM
Please Verify This Step.
You Must map a transformation in DTS Designer to establish the relationship between the source and destination columns