none
Err Code: 0xC0209303. Using SSIS for Data from Access2007 to MSSQL2008 using SSIS created with VS2008

    Question

  • Text of err:

       Code: 0xC0209303
       Source: CTS_01AbcTest Connection manager "SourceConnectionOLEDB"
       Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_64BIT_ERROR.  The requested OLE DB provider Microsoft.Jet.OLEDB.4.0 is not registered -- perhaps no 64-bit provider is available.  Error code: 0x00000000.
    An OLE DB record is available.  Source: "Microsoft OLE DB Service Components"  Hresult: 0x80040154  Description: "Class not registered".

    History:

    After migrating from WinXP & old PC to Win10 with new SolidStateDrive PC.

    Old PC worked OK using this Script:  xp_cmdshell 'dtexec /f "C:\SSIS\AbcTest.dtsx"'

    Now xp_cmdshell will always give above Err but Package will Run OK with 'Execute Package Utility' on DoubleClick in WindowsExplorer.

    After searching the web I found this:

    'Navigate to “Debugging” option from left panel and from Right panel, change Run64BitRuntimevalue to false.'

    But I just cannot find these Panels.

    I would be extremely grateful if you can help.   

    BTW: I upgraded to Access2016 hoping it might be 64bit but same problem remained.

    Thank you

    Padraig

     

    Friday, October 26, 2018 12:17 PM

All replies