Reading Ad Hoc Text Files with OpenDataSource

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Timothy A Wiseman » Reading Ad Hoc Text Files with OpenDataSource...

13 posts, Page 2 of 2

««1 2

Reading Ad Hoc Text Files with OpenDataSource

Rate Topic

Display Mode

Topic Options

Author

Message

micke-1097755

Posted Tuesday, November 23, 2010 3:18 AM

Forum 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

Philippe Cand

Posted Tuesday, November 23, 2010 3:19 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 29, 2013 10:28 AM
Points: 46, Visits: 262

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

MyDoggieJessie

Posted Tuesday, September 06, 2011 10:39 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 8:50 AM
Points: 2,035, Visits: 3,759

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" Wink

Post #1170588

« Prev Topic | Next Topic »

13 posts, Page 2 of 2

««1 2

Permissions