May 23, 2006 at 8:35 am
I get the following error message when a DTS Package is executed from jobs. Well the user
CACI\svcPM2SQL is not part of admin group on the sql server machine. however it is a sysadmin with sql server. any idea what could be going on here?
Executed as user: CACI\svcPM2SQL. ...nStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecutePackageTask_1 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSExecutePackageTask_1; DTSStep_DTSDataPumpTask_1: 5000 Rows have been transformed or copied.; PercentC... Process Exit Code 1. The step failed.
May 23, 2006 at 8:57 am
I would guess that, since the task starts but appears to abort in the middle, the process is either running out of disk space resource somewhere or being interrupted by another process.
John
May 23, 2006 at 9:03 am
There is ample disk space available.
May 23, 2006 at 9:32 am
You'll get more information from the DTS package log. If you haven't enabled logging in the packages, do so and start the job again.
Greg
Greg
May 23, 2006 at 10:41 am
well not having luck with logging dts package. even though i enable it per following link http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_dts_pkgmng_6vqr.asp . however per this link I should do the following
On the Package menu, click Save As, and then in the Save DTS Package dialog box, in the Location list, select Meta Data Services.
and I dont see Meta Data Services option when I save the package. Its not in the drop down.
error in package job history is following:
Executed as user: CACI\svcPM2SQL. DTSRun: Loading... DTSRun: Executing... Error: -2147220383 (80040461); Provider Error: 0 (0) Error string: This DTSPackage has not been saved to the Repository, so Lineage cannot be written to the Repository. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 700. Process Exit Code 1. The step failed.
May 23, 2006 at 4:06 pm
Apparently, the package hadn't been saved to the repository prior to adding logging. So, if you want to log to the repository, you must save the package to Meta Data Services first.
I always save packages and package logs to SQL Server. I have no need for the lineage information and I like to use owner passwords on packages, which isn't allowed for packages saved in the repository. I've also read that packages executed from the repository run slower.
Greg
Greg
May 25, 2006 at 11:06 am
Additionally, Meta Data Services repository was removed as a storage option for DTS packages by SQL 2000 SP3. You'd be better off storing them in msdb's tables or as com files.
Greg
Greg
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply