SSIS Dinamically call a SSIS package (Filesystem location)

Page Details

First published by:
PedroCGD
on 05-19-2009
Last revision by:
PedroCGD
on 07-15-2009
This page has not yet been rated

SSIS Dinamically call a SSIS package (Filesystem location)

Filed under: [Edit Tags]

To call dinamically a package located at the filesystem, you can do that inside the package (1) or from a bat file (2)

1. From a bat file

Create a bat file and add the following code: (replace MyPackageName by your package name)

set OLDDIR=%CD%
dtexec /F "%OLDDIR%\MyPackageName.dtsx

2. From a SSIS package

Add a script task to your controlflow, create a ssis variable uvRootFolder, set the variable name inside ScriptTask in the ReadWriteVariables and add the following code to it:

 

I hope this tip help you! PedroCGD

Recent Comments

Leave the first comment for this page.