SQL Server Performance

The Execute Package task is not working properly

Discussion in 'SQL Server DTS-Related Questions' started by pallavi, Jan 6, 2006.

  1. pallavi New Member

    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 />
  2. satya Moderator

    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.
  3. pallavi New Member

    Thanks a lot satya

    Regards!
    Pallavi

Share This Page