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.

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).|||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!

|||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.|||

execute the package with the dtsrun.exe found in

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

regards

JG

|||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|||

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.

|||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.