January 6, 2012 at 11:33 am
Team:
This fantastic package runs locally ( from Visual Studio 2005 ) real well. I deployed it as a job in the
server and it failed. The error message is listed below.
Briefly, here is what I do
1. Query a database, get the data ( Data FlOW TASK ) and dump the data to excel.
Message
Executed as user: <XXXXXX-XXXXX>\<XXXXX>. ... for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 6:01:00 PM Error: 2012-01-05 18:01:01.52 Code: 0xC0202009 Source: copy_rpt_data_to_excel_files Connection manager "excel_conn_manager_for_output" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040154. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". End Error Error: 2012-01-05 18:01:01.52 Code: 0xC020801C Source: GET SSRS RPT data Excel Destination [2860] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "excel_conn_manager_for_output" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection met... The package execution fa... The step failed.
January 6, 2012 at 11:35 am
This could be a permission issue for the SQL Agent account on the location of the Excel file.
January 6, 2012 at 11:37 am
January 6, 2012 at 11:43 am
Your server needs the Office Suite installed, and possibly the exact driver you're looking for. You'll also most likely have to turn on the 'run in 32 bit mode' option in the job.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 6, 2012 at 11:47 am
Evil Kraig F (1/6/2012)
Your server needs the Office Suite installed, and possibly the exact driver you're looking for. You'll also most likely have to turn on the 'run in 32 bit mode' option in the job.
My money is on Chuck with the 64/32 bit issue 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 6, 2012 at 11:53 am
Gentlemen, good job!
My next question, is how do I "run in 32 bit mode?"
Where can I find this setting ? Is this something I have to set in the package ?
January 6, 2012 at 12:34 pm
Read through the link that I added earlier. I believe there are some instructions in there.
January 6, 2012 at 12:38 pm
Phil Parkin (1/6/2012)
Evil Kraig F (1/6/2012)
Your server needs the Office Suite installed, and possibly the exact driver you're looking for. You'll also most likely have to turn on the 'run in 32 bit mode' option in the job.My money is on Chuck with the 64/32 bit issue 🙂
Heh, I usually see a different error when I forget to flip on the 32 bit mode. Figured it was a driver not being reg'd. Good call Chuck. 🙂
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply