Hi,

I have a DTS that run weel when I run it manualy I mean when I right click
on it et select Execute DTS.

When I Scheduled The DTS it fails.
The DTS is importing Data From an accpac Application with a SYSTEM DATA
SOURCE ODBC driver
The accpac Files are on another server.
First I was using a Map Drive.
After I try a UNC path.
I test the UNC path and it work ok
I start manualy the DTS and it work ok

The user that run the sql Agent service and MSqlServer is an domain
Administrator user


Soon as I scheduled the DTS it fails with this error message :


Step 'Copy Data from JC65ANME JC CustomerManager Names to JC65ANME Step'
failed

Step Error Source: Microsoft OLE DB Provider for ODBC Drivers
Step Error Description:[SSDB]Path invalid opening user file in SI_AppCreate
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:0

I dont know what else I can try

Do you have any idea

Thanks in advance!

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

Hi I have more information about the error form the Job History Error details

Executed as user: FN\da. ...SRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnError:
DTSStep_DTSExecutePackageTask_1, Error = -2147467259 (80004005)
Error string: Copy Data from JC65ASUM JC Job Summary to JC65ASUM
Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: Help context: 0
Error Detail Records:
Error: -2147467259 (80004005);
Provider Error: 1207 (4B7)
Error string:
Error source:
Help file:
Help context: 0
DTSRun OnError: DTSStep_DTSExecutePackageTask_1, Error =
-2147467259(80004005)
Error string: Copy Data from JC65ANME JC CustomerManager Names to
JC65ANME Step: [SSDB]Path invalid opening user file in SI_AppCreate
Error source: Microsoft OLE DB Provider for ODBC Drivers
Help file: ... Process Exit Code 0. The step succeeded.

If that can help

I Have no idea of what is going on
Remember that the path is good because the DTS work well when I start de DTS
manualy.



"GC" wrote:

GC,

When you run the DTS manually, you run with your login's rights.

We you run DTS from a scheduled job how it runs depends on who owns the SQL
Agent job:
1 - a sysadmin - Runs as the SQL Server service account.
2 - a non-sysadmin - Runs as the SQL Agent Proxy Account.

Therefore, the proper account must be granted rights to the file path that
you are trying to access. (Therefore, these accounts must be domain
accounts, not just running as local system.)

RLF

"GC" <GC (AT) discussions (DOT) microsoft.com> wrote