64bit problem?

Hot Topic

There is a way to use an arbitrary parameter in OLAP Report (not associated with a dimension)?
Database Diagram error on SQL 2005
Inserting large amounts of data
Setting Passwords In Connections Using Script Task
How to join 2 datasets without sorting
More Merge Join question
Default Web Site using wrong IP
Failed SQL 2005 SP1 installations (Hotifx.exe crashes)
how do I determine how many columns there are in a file?
Implementing message queue in SQL Server 2000

SQL Server

parallel execution
escaping a string
metadata driven SSIS package--table variable
Parameters in URL - Problem
Filtering Table name with Parameter
Connection failed!
using package variables as parameters in Execute Sql Task
Customize Error Messages
Freeze Panes?
SSIS and COM

64bit problem?

I run SQL Server 2005 on a Windows 2003 64-bit server. I have created a package where I run an execute t-sql statement task. In the t-sql I have the following:

select * from
OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source="c:\test.mdb";User ID=Admin;Password=').pubs.dbo.data

and I get the following error:

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

Answer this question

64bit problem?

  • shawjh

    But opening an OLEDB source for MS Access will not allow me to use OpenDatasource from SQL, right

    Therefore there is no way to use OpenDataSource from SQL 2005 64 bit


    The idea is that I would like to run a complex stored procedure in the package, and that the stored procedure needs the data in Access as well.

  • Venkataraghavan Sheshadri

    precondition >> I run SQL Server 2005 on a Windows 2003 64-bit server<<

    further ssis dosnt run on 2000 but on 2005.

    if you on 2005 run a ssis package it will use the 32bit jet driver and your import will work fine

    regards

    G.

  • markiemooster

    DtsRun is for DTS 2000, it would not be able to run SSIS package.
    To run SSIS use DTEXEC from
    c:\Program Files\Microsoft SQL Server\90\Dts\Binn or
    c:\Program Files (x86)\Microsoft SQL Server\90\Dts\Binn

  • James Klimek

    execute the package with the dtsrun.exe found in

    c:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn

    regards

    JG

  • Noel L

    To run package in 32-bit mode in Visual Studio, right click SSIS project and select properties. Set the property Debugging > Run64BitRuntime to false.

    To access Jet database (e.g. as a source) without SQL Server:
    1) create OLE DB Connection Manager, select "Native OLEDB\Microsoft Jet 4.0" provider in the top drop down box, configure path to database.
    2) from Toolbox drop OLE DB Source to the data flow, configure it to use this connection manager.

  • DLCarp

    I am a newbie with SSIS and I am not yet in the post-deployment stage. I am running the package from Visual Studio 2005.
    How to choose to run it in 32 bit mode
    And how to run the Jet datbase directly and not through SQL server

    Thanks again!

  • bogdanleon

    There is only 32-bit version of Jet provider.

    You access it on 64-bit machine, if you run SSIS packages in 32-bit mode (using 32-bit dtexec from Program Files (x86) or setting appropriate option in project), and access Jet database directly (not through SQL server).

  • 64bit problem?
Answer this question