SSIS Package Run - SQL Server Forums

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

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.

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

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

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

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources