Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

SharePoint, SSIS Package, and SQL job using package config file

  Asked By: Bhavani    Date: Oct 04    Category: Sharepoint    Views: 1857

Here's what we're trying to do:

Copy Excel files from a network folder to a SharePoint document library. The
files are created using a SQL job from a SQL database. We're copying them using
an SSIS package. The SSIS package works just fine in Business Intelligence
Development Studio but the connection is not valid when we run the package using
a SQL job.

The error we're getting is:

Message
Executed as user: BDS\dotnetsqluser. ... 9.00.4035.00 for 32-bit Copyright (C)
Microsoft Corp 1984-2005. All rights reserved. Started: 9:01:46 AM Error:
2009-07-07 09:01:47.31 Code: 0xC001401E Source: CoappExcel Connection
manager "Activity Type.xls 1" Description: The file name
"\\oasppexweb01.ads.state.mo.us\coappexcel\Activity Type.xls" specified in the
connection was not valid. End Error Error: 2009-07-07 09:01:47.31 Code:
0xC001401D Source: CoappExcel Description: Connection "Activity
Type.xls 1" failed validation. End Error Error: 2009-07-07 09:01:47.32
Code: 0xC001401E Source: CoappExcel Connection manager "Activity.xls 1"
Description: The file name
"\\oasppexweb01.ads.state.mo.us\coappexcel\Activity.xls" specified in the
connection was not valid. End Error Error: 2009-07-07 09:01:47.32 Code:
0xC001401D Source: CoappExcel Description: Connection "Activity.xls 1"
failed validation. End Erro... The package execution fa... The step failed

Share: 

 

1 Answer Found

 




Tagged: