none
SSIS Error usind xp_cmshell dtexec SQL2008 64BIT and w2k8 64 bit

    Question

  • Hello anybody

    I have problem when I try to run this command

    exec Master.dbo.xp_cmdshell 'dtexec /DTS "\MSDB\DTStest10" /SERVER SERVER1 /CHECKPOINTING OFF  /REPORTING V '

    Is very simply, export table to excel file.
    when run manually using right click "run package" on SQL SSIS, is fine

    NOTE: I used DTS on sql2000 and SSIS sql2008 32bit, No problel the command, but I don;t know what happen, I read many post but any is clear for me

    regards

     


    Felipe Script Center


    • Edited by Felipedom Friday, May 17, 2013 6:13 AM
    Friday, May 17, 2013 6:06 AM

Answers

  • There are a couple lines being returned that indicate the error.  Paste those.

    I suspect that you are using a connection manager (Excel comes to mind) that does not have a 64 bit driver.

    Try putting the full path to dtexec and use the 32 bit version.  That should be in "\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn" http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx


    Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com


    • Edited by Russ Loski Friday, May 17, 2013 10:14 AM
    • Marked as answer by Felipedom Saturday, May 18, 2013 5:49 AM
    Friday, May 17, 2013 10:13 AM

All replies

  • Hi Felipedom,

    Could you re-run the command in SSMS by selecting Query to Result Text and paste the error message?  (In SSMS under Query ->Results To->Results to Text)

    From the looks of it, Failed to acquire Destination connection seems to be the message. Could you check the connection strings?


    Regards, Karthik Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Friday, May 17, 2013 6:16 AM
  • There are a couple lines being returned that indicate the error.  Paste those.

    I suspect that you are using a connection manager (Excel comes to mind) that does not have a 64 bit driver.

    Try putting the full path to dtexec and use the 32 bit version.  That should be in "\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn" http://msdn.microsoft.com/en-us/library/ms162810(v=sql.105).aspx


    Russel Loski, MCT, MCSA SQL Server 2012, 2008, MCITP Business Intelligence Developer and Database Developer 2008 Twitter: @sqlmovers; blog: www.sqlmovers.com


    • Edited by Russ Loski Friday, May 17, 2013 10:14 AM
    • Marked as answer by Felipedom Saturday, May 18, 2013 5:49 AM
    Friday, May 17, 2013 10:13 AM
  • Yes, the problem "full path 32Bit" but only is fine when I Used SSIS File System, anyway I finished my store procedure and It's working.

    Tk

    Regards


    Felipe Script Center

    Saturday, May 18, 2013 5:58 AM