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 «««123

Problem extracting character/string values from an Informix database using SSIS 2008 Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 1:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 4, 2015 3:44 PM
Points: 15, Visits: 112
I have this exact same issue and I'm redirecting errors from an ado.net data source to a multi cast but I'm still getting blank values. Any ideas? I'm pulling from Interbase with their native 32 bit odbc driver I've registered as a system data source.
Post #1446317
Posted Thursday, April 25, 2013 1:13 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 4, 2015 3:44 PM
Points: 15, Visits: 112
I have this exact same issue and I'm redirecting errors from an ado.net data source to a multi cast but I'm still getting blank values. Any ideas? I'm pulling from Interbase with their native 32 bit odbc driver I've registered as a system data source.
Post #1446319
Posted Thursday, April 25, 2013 8:12 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 27, 2015 8:35 PM
Points: 2,499, Visits: 3,140
How about using a derived column to cast the strings to code page 1252 ? I suspect a code page problem of some kind.

Steve
(aka sgmunson)

Helpful Investing Info
Healthy Living Info
Helpful Business Info
Post #1446520
Posted Monday, April 20, 2015 9:06 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 24, 2015 5:44 PM
Points: 1, Visits: 3
Please!! did you solve it?? I realy need this solution! Thanks
Post #1678499
Posted Monday, April 20, 2015 6:13 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 27, 2015 12:19 AM
Points: 184, Visits: 659
Did you try all of the suggestions in the prior two pages?
Post #1678711
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse