The Execute Package task is not working properly | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

The Execute Package task is not working properly

Hello everyone<br /><br />I have created a package called TransferPackage. This package does the following things<br />1. Execute Process task to execute the batch file ‘CopyLocal.bat'<br />2. Execute SQL task : for creating tables<br />3. Execute Package Task : for executing the package ‘TransferFromParadox'<br />4. Execute SQL taks : for execuingt TransferMaster Procedure.<br /><br />The ‘TransferFromParadox’ package, imports the data from Paradox5.x (.db) tables to SQL server.<br /><br />When I execute the package ‘TransferFromParadox’ directly, It works fine.<br />but when i execute it in the TransferPackage It gives me error as<br /><br />Package Error<br />—————————<br />Error Source : Microsoft Data Transformation Services (DTS) Package<br /><br />Error Description : (1<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />aradoxToSQL) SubStep ‘DTSStep_DTSDataPumpTask_4′ failed with the following error: <br /><br />Execution was canceled by user.<br /><br />(1<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />aradoxToSQL) SubStep ‘DTSStep_DTSDataPumpTask_3′ failed with the following error: <br /><br />Execution was canceled by user.<br /><br /><br />(1<img src=’/community/emoticons/emotion-4.gif’ alt=’:p‘ />aradoxToSQL) SubStep ‘DTSStep_DTSDataPumpTask_2’ failed with the following error: <br /><br />Execution was canceled by user.<br /><br /><br />Execution was canceled by user.<br /><br />—————————<br />OK <br />—————————<br /><br /><br /><br />Can anyone tell me why this is happening? and what should be done to remove this error<br /><br />Thanks in advance<br /><br />Regrds!<br />Pallavi<br /><br />
If you have scheduled this package or trying to execute using an account, then ensure that account or SQLAgent service account has requird privileges on the batch files and path involved in this package execution. Check DTS log for more information on the error stated/. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks a lot satya Regards!
Pallavi
]]>