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 |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2009-04-21 : 17:11:43
|
| Folks: I run this SSIS Package from Management Studio using 'dtexec' and it throws an Error but for some reason it display that 'Query executed successfully' .. Here are the messages: .....Microsoft (R) SQL Server Execute Package UtilityVersion 9.00.3042.00 for 32-bitCopyright (C) Microsoft Corp 1984-2005. All rights reserved.NULLStarted: 5:13:51 PMError: 2009-04-21 17:13:52.35 Code: 0xC001000E Source: Package Description: The connection "EnvConfig" is not found. This error is thrown by Connections collection when the specific connection element is not found.End ErrorWarning: 2009-04-21 17:13:52.35 Code: 0x8001F02F Source: Package Description: Cannot resolve a package path to an object in the package ".Connections[EnvConfig].Properties[ConnectionString]". Verify that the package path is valid.End WarningWarning: 2009-04-21 17:13:52.35 Code: 0x80012017 Source: Package Description: The package path referenced an object that cannot be found: "\Package.Connections[EnvConfig].Properties[ConnectionString]". This occurs when an attempt is made to resolve a package path to an object that cannot be found.End WarningWarning: 2009-04-21 17:13:52.42 Code: 0x80012059 Source: Package Description: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.End WarningProgress: 2009-04-21 17:13:52.51 Source: Copy and Rename Files Operation Complete: 100% completeEnd ProgressDTExec: The package execution returned DTSER_SUCCESS (0).Started: 5:13:51 PMFinished: 5:13:52 PMElapsed: 0.562 secondsNULL |
|
|
|
|
|
SSIS Fails but returns Success