Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SSIS Package Run

Author  Topic 

tpratyush
Starting Member

17 Posts

Posted - 2013-09-30 : 03:08:55
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

17 Posts

Posted - 2013-09-30 : 03:43:36
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

52326 Posts

Posted - 2013-09-30 : 06:32:06
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
   

- Advertisement -