Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS Doubt in DFT Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 4:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 17, 2014 4:11 AM
Points: 6, Visits: 16
Hi All,

I have one Query in SSIS , i am have OLEDB As Source and Excel As Destination ,

Here Why i need to convert data as Unicode ???


Regards

Anbarasu.T.R
Post #1545327
Posted Wednesday, February 26, 2014 4:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 8:16 AM
Points: 271, Visits: 1,281
Because, presumably the data entering the SSIS pipeline from the oledb source is non-unicode.

Excel requires the data be unicode prior to loading to the worksheet, hence the need for a conversion as SSIS pipeline doesn't implicitly convert between unicode and non-unicode

The same would apply if you were loading from an excel source to the oledb destination - you'd need a conversion step to convert the excel (unicode) prior to loading the oledb (non-unicode) destination.

Hope this helps
Post #1545328
Posted Wednesday, February 26, 2014 4:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 17, 2014 4:11 AM
Points: 6, Visits: 16
[/font]Thanks Buddy..[font="Wingdings"]
Post #1545333
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse