Hi,

Any idea on using schtasks.exe in BAT file to auto-executing the SSIS?

I have issue in putting the value after /TR as below:
"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /File
"D:\Source\A.dtsx" /DECRYPT ABC /MAXCONCURRENT " -1 " /CHECKPOINTING OFF
/REPORTING V /CONNECTION DestinationConnectionOLEDB;"\"Data Source=.;Initial
Catalog=Dev;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto
Translate=false;\""

it only allows to key in D:\Source\A.dtsx instead of above statement.

Please advice
thank you.

GL