SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 SSIS Package Run
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tpratyush
Starting Member

India
17 Posts

Posted - 09/30/2013 :  03:45:02  Show Profile  Reply with Quote
Hi all,
Recently my terminal was migrated from Windows XP to win7. All my SSIS packages were running perfectly in windows XP, but it isn't the case with win7. When I am trying to run a package, in my experience it is not able to get the data from input excel source.

Basic Information:
using win7 64 bit
working on SQL server 2008 R2

Thanks in advance


Thanks and Regards,
Pratyush Tripathy

tpratyush
Starting Member

India
17 Posts

Posted - 09/30/2013 :  03:47:17  Show Profile  Reply with Quote
Precisely when I am trying to fetch the records from Excel file, it is giving me this error.

Msg 7308, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' cannot be used for distributed queries because the provider is configured to run in single-threaded apartment mode.


Thanks and Regards,
Pratyush Tripathy
Go to Top of Page

NeilG
Aged Yak Warrior

United Kingdom
530 Posts

Posted - 09/30/2013 :  03:59:17  Show Profile  Reply with Quote
That looks like some kind of driver problem not an ssis problem, I'd look at confirming the jet drivers for ms excel, access etc are on your new machine

-----------------------------------------------
Learning something new on SQL Server everyday.
Go to Top of Page

tpratyush
Starting Member

India
17 Posts

Posted - 09/30/2013 :  04:01:35  Show Profile  Reply with Quote
@NeilG Thanks a lot first of all.

I would like to share that I have check with this error in Google also, they are suggesting to install 64 bit driver. But then again, there is no 64bit driver available. What should I do now?

Thanks and Regards,
Pratyush Tripathy
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 09/30/2013 :  06:27:36  Show Profile  Reply with Quote
try running packages after setting 64BitRuntime to False in project properties.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tpratyush
Starting Member

India
17 Posts

Posted - 09/30/2013 :  09:18:49  Show Profile  Reply with Quote
@Visakh16

Not working mate. That was basic though. Changed it prior to posting here.

Thanks and Regards,
Pratyush Tripathy
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 09/30/2013 :  10:07:41  Show Profile  Reply with Quote
Or Next Try

can you try running this and then running your packages again?

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO


if it still doesnt work try installing 64 bit driver (ACE provider) and connect using it

http://www.microsoft.com/en-us/download/details.aspx?id=13255

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.36 seconds. Powered By: Snitz Forums 2000