dtexec /L Logging to Text file is not working

• David Bird

  SSCarpal Tunnel

  Points: 4669

  More actions

  March 13, 2007 at 3:28 pm

  #116600

  I am looking to promote a SSIS package to various servers. The name and location of the text Log File setup in BIDS for the package is expected to change. The SSIS package will be executed through a 3rd party scheduler as a batch command file.

  I am trying to use this command to change the location

  dtexec /F DASD_Database_List_export.dtsx /L "DTS.LogProviderTextFile.1;E:\Log.txt"

  For which I am getting this error:

  Description: The connection manager "E:\log.txt" is not found. A component failed to find the connection manager in the Connections collection.

  I tried Set command approach from

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72104

  It did not work.

  Has anyone been successful in using the dtexec log parameter DTS.LogProviderTextFile.1? Could you post how you got it to work? Thanks

  David Bird

• Sean McKinley

  Valued Member

  Points: 58

  More actions

  June 6, 2007 at 1:49 pm

  #711230

  I am having the same issue.  Anyone know the answer?

• Jolene Yuan

  SSC Rookie

  Points: 45

  More actions

  July 28, 2011 at 10:02 am

  #1360273

  Try below:

  DTEXEC /FILE "pkgDirecotry\pkgName.dtsx" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package.Variables[variableName].Properties[Value]";variableValue /REPORTING EWCDI > .\Logs\pkgName_%YYYYMMDD%_%HHMM%.log