DTS 2000 Package Data Loading Issue in SQL2008/R2

Question

Friends,

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.

Any idea?

Regards,

Irfan Ahmad

Answer 1

Hi Irfan,

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

Answer 2

Look data i beleive its in correct form....

BRANCH|ACCT_TYPE|CCY|ACCT_NO|ACCT_DESC|ACCT_OPEN_DATE|ACCT_CLOSE_DATE|ACCT_STATUS|ACNT_SEIZE|HOME_ADDRESS|CLIENT_TYPE|OWNERSHIP_TYPE|NIC|CNIC|ACNNT_CODE|MOTHERS_MAIDEN_NAME|BIRTH_DATE|GENDER|MARITAL_STATUS|CREATEDATE|CLIENT_NO|OFFICE_ADDRESS|OFF_PHONE|RES_PHONE|MOB_NUMBER|NTB

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|

Answer 3

Then the mapping is not

---

Arthur My Blog

Answer 4

The 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.

---

Chuck

Answer 5

noooo..data format is correct if i execute DTS package then its work fine...but through SSIS its creating issue....plz suggest anything more !!!

Answer 6

any idea?

Answer 7

Hi.. Irkan_lhr.

Please Verify This Step.

You Must map a transformation in DTS Designer to establish the relationship between the source and destination columns

Best Regards

---

Leonardo Martínez