SSIS Package fails accessing Shared folder containing Excel Files

I have an SSIS package that fails intermittently since 2/18/2013(Monday) mt production Server. The SSIS package accesses excel files on a shared folder. SSIS package has been running successfully for 30 days until this week. SSIS package runs successfully 3 times then fails. Then run again SSIS package runs successful. Below is error:

Executed as user: SCONET\svc_GCCDARFileLoad. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 32-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:10:01 AM Error: 2013-02-22 11:10:16.06 Code: 0xC0202009 Source: GCCReportLoad Connection manager "ExcelConnection" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft Office Access Database Engine" Hresult: 0x80004005 Description: "External table is not in the expected format.". End Error Error: 2013-02-22 11:10:16.06 Code: 0xC020801C Source: Load Data From Excel to Database Table Source - Query [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER . The AcquireConnection method call to the connection manager "ExcelConnection" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2013-02-22 11:10:16.07 Code: 0xC0047017 Source: Load Data From Excel to Database Table SSIS.Pipeline Description: component "Source - Query" (1) failed validation and returned error code 0xC020801C. End Error Error: 2013-02-22 11:10:16.07 Code: 0xC004700C Source: Load Data From Excel to Database Table SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2013-02-22 11:10:16.07 Code: 0xC0024107 Source: Load Data From Excel to Database Table Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:10:01 AM Finished: 11:10:16 AM Elapsed: 14.704 seconds. The package execution failed. The step failed.

Feb 22 '13 #1

Subscribe Post Reply

2284

Similar topics

Accessing Shared Folder through C#

by: Chandra Sekhar | last post by:

I want to access a shared folder of a different machine (Mapped to my server) say E:\ (which is actually \\myothermac\c$\somefolder") from C#. If I use string strFolder = "E:\myNewFolder"; if...

C# / C Sharp

Alternatives to Creating a Shared Folder?

by: Keith Smith | last post by:

Are there any alternatives to sharing a database without creating a shared folder? I guess I could create a client/server app, but I'm trying to avoid that. On the other hand, I am also trying to...

C# / C Sharp

Problem While Connecting a folder containing sql files in Execute SQL Task in Execute Sql statements in loop example

by: satish | last post by:

hi, i have a problem while connecting the Folder in executing sql task in execute sql statements in loop example in Intergration Services --2005 the actual problem -- i have given the sql source...

Microsoft SQL Server

Decimating Excel files

by: gonzlobo | last post by:

No, I don't want to destroy them (funny how the word 'decimate' has changed definition over the years) :). We have a data acquisition program that saves its output to Excel's ..xls format....

Python

Creating an Excel Macro to index the titles of a folder of Excel files

by: Teres | last post by:

Hello, I am trying to do an macro that go through all excel files in a folder, bring their name and copy their name (title) to an worksheet. I don't have a lot of experience with excel. Can...

Desktop Software

how to open a directory containing many files?

by: aboxylica | last post by:

i know how to open a file and access its elements..now i have to open a folder containing these files and work with these files.. the normal open("directoryname") is giving me an error. any...

Python

Accessing Shared folder on LAN

by: questionit | last post by:

Hi While accessing shared folder on the local network, it was possible to access the folder by just entering the workstation IP in windows explorer - and the shared folders will show up. From...

Networking - Hardware / Configuration

Error : Calling SSIS package from .Net

by: pinky22 | last post by:

I am calling SSIS package from a .Net windows UI. Both SSIS & .Net app are created in 2008. The SSIS package is stored in file system. When I ran .Net app I got error- The package failed to...

Microsoft SQL Server

How can I open all excel files in a folder and its sub folders

by: philqw78 | last post by:

I get sent a folder containing zip files. I extract the zips to another folder. This then gives me 65 sub folders(directories), each with an excel and a text file. I wish to open all the excel...

Visual Basic 4 / 5 / 6

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++