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
 Transact-SQL (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:08:55  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:43:36  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

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 09/30/2013 :  06:32:06  Show Profile  Reply with Quote
duplicate of

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=188544
please dont cross post

------------------------------------------------------------------------------------------------------
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.03 seconds. Powered By: Snitz Forums 2000