Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
capella07
Starting Member
46 Posts |
 Posted - 2008-03-17 : 11:23:40
|
| Hello, allI've got a DTS package in SQL Server 2000 in which after an Access file is written to, I need to have it Zipped so that it can be FTP'd elsewhere. The entire DTS package works fine with the exception of the Zipping step. The really odd thing is, every thing works fine, including the zip step when each step is executed manually step by step - no errors and the file is zipped as it should be, but when the entire package is executed, I get the error on that step. The error is: "CreateProcessTask 'DTSTack_DTSCreateProcessTask_2': Process returned code 1, which does not match with the specified SuccessReturnCode of 0."Googling that error and variations of it turned up nothing.Some info:I'm using PKWare's Command Line PKZip version 4 for the zipping step. I've checked, double checked, and triple checked that I'm using the right syntax in the "Parameters" box in the package's zip step. The line reads: -add "C:\Exports\RVM\PayrollExports\RVMPayrollExport.zip" "C:\Exports\RVM\PayrollExports\RVMPayrollExport.mdb"Suspecting it may be a rights issue, as far as whether the DTS package can execute the PKZip executable, I checked the security settings for that program against the rights settings on another server of ours on which I know this setup works (Zipping files from DTS packages). They look to be set up the same, although I'm in no way experienced enough to be sure the settings are right, or even if that's the problem at all!I don't know if this is enough info for anyone to help, so if you need more, please let me know and I'll provide what you need to be able to help. I've been working on this problem for FOUR DAYS and I (and my boss) would like to get this fixed!Thanks in advance for anyone's help!=====================================f u cn rd ths, u cn gt a gd jb n prgrmng |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-03-17 : 12:28:28
|
| Sounds like a rights issue to me. Have you got an output file on the DTS package? This would give you more information on the error and possibly tell you the exact problem. |
 |
|
|
capella07
Starting Member
46 Posts |
Posted - 2008-03-17 : 13:18:57
|
| Thanks for replying, RickD.I wouldn't be suprised if it IS a rights issue, but the confusing thing to me is, if that is the case, then why would it run okay step by step, but not when the whole package is run?How exactly do I produce an output file?Thanks!=====================================f u cn rd ths, u cn gt a gd jb n prgrmng |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-17 : 22:34:39
|
| You can enable package logging to get details. |
|
|
|
capella07
Starting Member
46 Posts |
Posted - 2008-03-18 : 09:31:35
|
Okay, that helps. Thanks, rmiao. I now have some more info to help research this. Did some Googling on the error info:Step Error Source: Microsoft Data Transformation Services (DTS) PackageStep Error Description:CreateProcessTask 'DTSTask_DTSCreateProcessTask_2': Process returned code 1, which does not match the specified SuccessReturnCode of 0.Step Error code: 80040496Step Error Help File:sqldts80.hlpStep Error Help Context ID:4900 Problem is, all of the info on this error was from forum posts from people having trouble with FTPing a file in a DTS, which turned out to be a rights issue for them. It's the file ZIPping step that's not working in my DTS, the FTP step works fine! Go figure... Anyway, that prompted me to make sure my security settings & syntax were all correct again... which are fine - again, at least according to the info for PKZip...Any suggestions?=====================================f u cn rd ths, u cn gt a gd jb n prgrmng |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-20 : 23:30:14
|
| Tried other tool like 7zip? |
|
|
|
|
|
|
|
|
DTS works step by step - NOT when whole pkg is run