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

Reading Ad Hoc Text Files with OpenDataSource Expand / Collapse
Author
Message
Posted Tuesday, November 23, 2010 3:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 23, 2010 5:50 PM
Points: 1, Visits: 1
I am having the same issue using MSADASQL for Text driver on SQL2008 64 Bit Machine.

Works fine on SQL2008 32 Bit machine.

Mick
Post #1024958
Posted Tuesday, November 23, 2010 3:19 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 12:10 PM
Points: 49, Visits: 279
My workaround is to run through a SQL Agent job with the SSIS step Execution Option set to use 32 bit runtime.

BI Guy
Post #1025529
Posted Tuesday, September 6, 2011 10:39 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 9:31 AM
Points: 3,910, Visits: 7,138
Did you ever get a fix for this? When attempting to do a similar thing I get the exact same error (on a 32-bit system)

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1170588
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse