Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DanA
Starting Member
3 Posts |
 Posted - 2006-09-17 : 08:31:04
|
| 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 ErrorError: 2006-09-17 09:10:30.20 Code: 0xC02020EA Source: SSIS-DU1-TT-toCSV-Package Log provider "{BB554FC1-60C5-4DCF-A091-9FDD47A92135}" 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 (empty) but it is obviously not a connection manager.What am I doing wrong?Thanks,DanA |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-17 : 14:38:10
|
| Think the connection needs to already exist and the /l associates the logger with it. You can then change the file used by the connection by an /set.dtexec /f mypackage.dtsx /l "DTS.LogProviderTextFile;log.txt" /Set "\package.Connections[log.txt].Properties[ConnectionString];c:\log.txt"Where log.txt is the name of a connection manager ==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
wkww2004
Starting Member
1 Post |
Posted - 2007-09-05 : 20:05:35
|
| During package design, I adding logging facility to a package, by choosing menu SSIS > Logging.At left list box, I check (tick) top level item (Package level),At right site, I select "Provider and Logs" tab, I choose "SSIS log for XML files" and click "Add" button, then I check item in datagrid below the button.I click on "Details" tab, I choose OnError Events, and I click "Save" button then type XML file name.I close "Configure SSIS Logs" window by clicking "OK" button.I close the package in "Business Intelligence Development Studio" window, and reopen the package. When it is opened, there 1 error showed up with the following error message :"Error loading Package1.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found."I see XML source of the dtsx package, but I do not find exact word "connection".Do you have similar problem with this? If yes, what should I do to resolve this issue?Thanks |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-09-06 : 04:20:57
|
| As nr suggests, it looks as though you need to create an appropriate connection manager and associate your log provider with it.Mark |
|
|
|
|
|
|
|
|
Logging in Dtexec