Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsDatabasesMicrosoft SQL Server

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old February 22nd, 2016, 11:42 AM
joshk joshk is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Aug 2006
Posts: 7 joshk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 36 m 17 sec
Reputation Power: 0
Question SSIS Package Fails When Run As Scheduled Job

Working in SQL Server 2012 with Visual Studio 2012 and MS Excel 2010.

I have a very simple SSIS package that exports the results of a SQL query to Excel and then emails the Excel file. The package runs just fine from BIDS, but when I try to run it from a scheduled job on the server it fails with the error below. I've verified that 32-bit runtime is off (it's supposed to be off), that the file path and sheet name are correct, and that everything else is as it should be. I've tried deleting and recreating the job, deleting and recreating the SSIS package, and deleting and recreating the Excel file. I've also tried replacing the package and the Excel file with the non-prod versions (the job runs on my non-prod server). The error below makes no sense at all.

I have a number of other packages that perform similar tasks and this is the only one failing.

Date 2/22/2016 11:34:39 AM
Log Job History (Report_CellPhoneList)

Step ID 1
Server {server name edited from post}
Job Name Report_CellPhoneList
Step Name Run SSIS Package
Duration 00:00:05
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: {username edited from post}. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:34:40 AM Error: 2016-02-22 11:34:42.02 Code: 0xC0202009 Source: Export to Excel Excel Destination [52] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2016-02-22 11:34:42.02 Code: 0xC02020E8 Source: Export to Excel Excel Destination [52] Description: Opening a rowset for "CellPhoneList$" failed. Check that the object exists in the database. End Error Error: 2016-02-22 11:34:44.27 Code: 0xC004706B Source: Export to Excel SSIS.Pipeline Description: "Excel Destination" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2016-02-22 11:34:44.27 Code: 0xC004700C Source: Export to Excel SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2016-02-22 11:34:44.27 Code: 0xC0024107 Source: Export to Excel Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:34:40 AM Finished: 11:34:44 AM Elapsed: 4.25 seconds. The package execution failed. The step failed.

Reply With Quote
  #2  
Old July 26th, 2016, 02:49 PM
ablesa ablesa is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2016
Posts: 1 ablesa User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 3 m 31 sec
Reputation Power: 0
Resolve?

I'm just wondering if you ever resolved this issue? I'm having the exact same problem and have not been able to find the solution yet.


Quote:
Originally Posted by joshk
Working in SQL Server 2012 with Visual Studio 2012 and MS Excel 2010.

I have a very simple SSIS package that exports the results of a SQL query to Excel and then emails the Excel file. The package runs just fine from BIDS, but when I try to run it from a scheduled job on the server it fails with the error below. I've verified that 32-bit runtime is off (it's supposed to be off), that the file path and sheet name are correct, and that everything else is as it should be. I've tried deleting and recreating the job, deleting and recreating the SSIS package, and deleting and recreating the Excel file. I've also tried replacing the package and the Excel file with the non-prod versions (the job runs on my non-prod server). The error below makes no sense at all.

I have a number of other packages that perform similar tasks and this is the only one failing.

Date 2/22/2016 11:34:39 AM
Log Job History (Report_CellPhoneList)

Step ID 1
Server {server name edited from post}
Job Name Report_CellPhoneList
Step Name Run SSIS Package
Duration 00:00:05
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: {username edited from post}. Microsoft (R) SQL Server Execute Package Utility Version 11.0.5058.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:34:40 AM Error: 2016-02-22 11:34:42.02 Code: 0xC0202009 Source: Export to Excel Excel Destination [52] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. End Error Error: 2016-02-22 11:34:42.02 Code: 0xC02020E8 Source: Export to Excel Excel Destination [52] Description: Opening a rowset for "CellPhoneList$" failed. Check that the object exists in the database. End Error Error: 2016-02-22 11:34:44.27 Code: 0xC004706B Source: Export to Excel SSIS.Pipeline Description: "Excel Destination" failed validation and returned validation status "VS_ISBROKEN". End Error Error: 2016-02-22 11:34:44.27 Code: 0xC004700C Source: Export to Excel SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2016-02-22 11:34:44.27 Code: 0xC0024107 Source: Export to Excel Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:34:40 AM Finished: 11:34:44 AM Elapsed: 4.25 seconds. The package execution failed. The step failed.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsDatabasesMicrosoft SQL Server > SSIS Package Fails When Run As Scheduled Job


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.

© 2003-2017 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap