dtexec logger

• Dinu E Anastasiu

  Ten Centuries

  Points: 1177

  More actions

  September 17, 2006 at 2:25 am

  #114796

  I am using the following parameter for a dtexec run:

   

  /logger "DTS.LogProviderTextFile.1;c:\log.txt"

   

  and I get the following messages:

   

  Error: 2006-09-17 09:10:30.20

     Code: 0xC001000E

     Source: SSIS-DU1-TT-toCSV-Package

     Description: The connection "c:\log.txt" is not found. This error is thrown by Connections collection when the specific connection element is not found.

  End Error

  Error: 2006-09-17 09:10:30.20

     Code: 0xC02020EA

     Source: SSIS-DU1-TT-toCSV-Package Log provider "{BB554FC1-60C5-4DCF-A091-9FDD

  47A92135}"

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

  End Error

   

  The file c:\log.txt actually exists but it is obviously not a connection manager.

   

  What am I doing wrong?

   

  Thanks,

  Dinu

• Regan Galbraith

  SSCertifiable

  Points: 5227

  More actions

  September 18, 2006 at 8:07 am

  #661041

  Did you actually add the Log in BIDS when designing the package? If not, then right-click on the control flow pane, and configure from there...