Click here to Skip to main content
15,901,122 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,

I am using Slowly Changing Dimension task from SSIS 2008 for delta load. Flat file is the input to slowly changing dimension task. I have observed that '--' character from file is converted into ' â€' after delta load.

What can be the issue.

Kindly help me to resolve this.

Regards,
Sameer K.
Posted
Comments
Sergey Alexandrovich Kryukov 22-Nov-13 2:11am    
How a character can be related to SCD or delta load? Not enough information. You need to provide a lot mode detail, perhaps some code sample.
—SA
sameer4feb 22-Nov-13 3:46am    
Input is the flat file and destination is the database table. Flat file contains few strings having '--' character but somehow after inserting this data to table '--' character is getting converted to 'â€'.
I am not able to post screenshot of package here.

Kindly help me to resolve this.

Regards,
Sameer
Sergey Alexandrovich Kryukov 22-Nov-13 9:36am    
Based on just this information? Are you serious?
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900