Have Geek Brain

How to use the \ L DOS command to create a log file in SSIS

I am trying to use the following command to execute to generate a log file for an SSIS package.

DTExec / FILE "C: \ Documents and Settings \ CP0808 \ My Documents \ Test.dtsx" / logger "DTS.LogProviderTextFile; c: \ log.txt"

But it got an error like below. Please advise.

Start: 12:03:20 Error: 2009-05-04 12: 03: 21.15 Code: 0xC001000E Source: Test Description: Connection "c: \ log.txt" not found. This error is thrown b y Collect connections when a specific connection element is not found. Termination error Error: 2009-05-04 12: 03: 21.18 Code: 0xC001000E Source: Test Description: Connection "c: \ log.txt" not found. This error is thrown b y Collect connections when a specific connection element is not found. Termination Error Error: 2009-05-04 12: 03: 21.21 Code: 0xC02020EA Source: Test Log Provider "{1AEAB490-1124-4A84-981F-7C1FDD80A721}" Description: Connection manager "c: \ log.txt" was not found. See the fa iled component to find the connection manager in the Connections collection. Completion error

Please help me to solve this problem ...

0


source to share


1 answer


You need to set up logging inside BIDS. It will show you that you need to configure the connection manager, and where you wrote "C: \ log.txt" you should have the name of the connection manager.



+1


source






More articles:


All Articles