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: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
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