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
 SSIS and Import/Export (2008)
 SSIS Package Run

Author  Topic 

tpratyush
Starting Member

17 Posts

Posted - 2013-09-30 : 03:45:02
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:47:17
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

530 Posts

Posted - 2013-09-30 : 03:59:17
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

17 Posts

Posted - 2013-09-30 : 04:01:35
@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

52326 Posts

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

17 Posts

Posted - 2013-09-30 : 09:18:49
@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

52326 Posts

Posted - 2013-09-30 : 10:07:41
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
   

- Advertisement -