• Hi,

    Code in your batch file would be something like this:

    C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec /f "c:\pkgOne.dtsx" /l "DTS.LogProviderTextFile;c:\log.txt"

    # /f "c:\pkgOne.dtsx" refers to the location of the saved SSIS pacakage.

    # /l "DTS.LogProviderTextFile;c:\log.txt" refers to the location of the logfile which will be used for logging. It is optional. you can just use :

    C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec /f "c:\pkgOne.dtsx"

    If you don't want logging in your scenario.

    Hope it Helps...!!!!

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)