separate log file for DTS package

• ckmoied

  Ten Centuries

  Points: 1092

  More actions

  November 18, 2007 at 6:33 am

  #184316

  Hi all,

  DTS package appends the log into a single log file after its execution. Is it possible that it logs the error in a separate file with a unique date.

  Regards

• Olga Smith

  Old Hand

  Points: 323

  More actions

  November 19, 2007 at 9:29 am

  #752361

  We had to write a bat file to move the logs to an archive directory and append the date to the name.

  As far as I know SQL Server 2000 didn't have that functionality built in.

  olga