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)