Monday, October 26, 2009

Execute Packages with DTExecUI and DTExec

The ssis package can be executed using DTExecUI and DTExec.

The DTExecUI can be called from command prompt and this will bring up the windows interface to run the ssis package.

The DTExec can be executed from the dos command prompt. The syntax for this will be

DTExec /f mypackage /set \package.variables[user::packagepath].value;"c:\ssis"

1 comment:

  1. I have heard about another way of how to fix recovery data sql 2005. Besides, you can visit my blogs at: http://daspeac.livejournal.com/ or http://daspeac.blogspot.com/ where I’m trying to share my experience with regard to data corruption issues.

    ReplyDelete