SSIS How to created a batch file for a pacakage
Hi there,
How to create a batch file for an ssis package ??
Thanks in advance
May 11th, 2011 4:46pm
Do you mean you want to execute a package off the file system?
If so use DTExec wrapped into a batch file or script of your choice (PS, Bat, VBSCript).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 4:48pm
if you mean execution of package, use DTEXEC as Arthur said,
but if you mean deployment of package, use
DTUTIL.http://www.rad.pasfu.com
May 11th, 2011 4:52pm
Actually i need to create a .bat file for it , for example "mypackage.bat" and then kick it off with a job trac in Mainframe
Free Windows Admin Tool Kit Click here and download it now
May 11th, 2011 5:14pm
Actually i need to create a .bat file for it , for example "mypackage.bat" and then kick it off with a job trac in Mainframe
so this will be executing the package, you can use DTEXEC as arthur said in your bat file. but you should also have your package .dtsx file deployed somewhere , in file system or Sql serverhttp://www.rad.pasfu.com
May 11th, 2011 5:18pm