January 16, 2007 at 4:22 am
I have a dts on a server. Same server i am trying to create a store procedure and using xp_cmdshell to run the dtsrun.
The package executes well through EM. Also the dtsrun for the package is running fine when i run through the dos but it fails when i run through query analyzer sql.
January 16, 2007 at 5:06 am
Are you getting an error message? If so, what does it say? Chances are that the account you are logged in as when you use DOS is not the same as the account that SQL Server runs under. If that's the case, check the permissions of both on dtsrun.exe and on any files or folders that the DTS package needs to create, modify or delete.
John
January 16, 2007 at 5:21 am
its surely a permission problem. but also check for the permissions of the account starting ur sql server if its not local system.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
January 16, 2007 at 7:00 am
SQLAgent service account is my domain account and permission wise everything is fine. The thing is iam using a custom task(to zip a file) in DTS. If i remove the custom task and execute from TSQL it works well. I think the problem is with the custom task. However the same DTS if i execute manually and through command line it's functioning well.
January 16, 2007 at 7:02 am
When i execute from TSQL or through Job i get the following error msg:
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnStart: DTSStep_ZIPFileTask.ZIPTask_1
DTSRun OnError: DTSStep_ZIPFileTask.ZIPTask_1, Error = -2147220421 (8004043B)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
Error Detail Records:
Error: -2147220421 (8004043B); Provider Error: 0 (0)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
DTSRun OnFinish: DTSStep_ZIPFileTask.ZIPTask_1
Error: -2147220421 (8004043B); Provider Error: 0 (0)
Error string: The task reported failure on execution.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 700
NULL
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply