x

Automatically convert Unicode Strings to Regular Strings

Is there a way in SSIS 2008 to automatically convert Unicode strings to regular strings? Is there perhaps a package setting or something?

I am reading several Jet datbases and all the string fields are coming across as Unicode Strings and the destination table they are being inserted into are defined as regular strings.

I don't want to create a data conversion transformation for every string field in all these tables I'm importing.

I'm just hoping there is a property that states to treat unicode as the default code page of 1252.

Thanks,

Pat Rogers

more ▼

asked Oct 26, 2009 at 05:47 PM in Default

avatar image

Pat Rogers
31 2 2 4

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Perhaps I am missing something, but as long as you aren't using characters that require Unicode, nothing prevents you from assigning the values to "standard" columns or variables. The implicit conversion is done for you.

declare @source as nvarchar(100) declare @target as varchar(100)

set @source = 'Paradimethylaminobenzaldehyde' set @target = @source

select @Target as [@Target], @source as [@source]

more ▼

answered Oct 26, 2009 at 06:18 PM

avatar image

Bob Hovious
1.6k 5 9 13

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2091
x1152
x14
x12
x5

asked: Oct 26, 2009 at 05:47 PM

Seen: 3862 times

Last Updated: Oct 26, 2009 at 11:41 PM

Copyright 2016 Redgate Software. Privacy Policy