With SQL 2005 I was able to develop a Batch File that did some file manipulation and then executed a SSIS package. The code to execute the SSIS package is: DTEXEC.EXE /De Password /F File path to package.dtsx
My Server was upgrade to SQL 2008 and now the Batch will still manipulate my files however, it will NOT execute the SSIS package.
Any ideas? Thanks Much