DTLoggedExec Copyright ¸ Davide Mauri 2006-2008 v.0.2.1.4
Some Rights Reserved. Licensed under the Creative Commons Attribution-NonCommercial-NoDerivs 2.5 Italy License.
More info here: http://dtloggedexec.davidemauri.it

Beta version, use at your own risk!

Target platform: 32bit

Logged Events: Error
Requested log provider: DTLoggedExec.LogProviders.ConsoleLogProvider

Creating custom event handler...
Loaded from assembly: DTLoggedExec.LogProviders.ConsoleLogProvider, Version=0.2.0.1, Culture=neutral, PublicKeyToken=null
ConsoleLogProvider Copyright ? Davide Mauri 2006-2008 v.0.2.0.1
Configuring log provider....
...Done.

Loading Package...
Package on file: C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\Test Package 1.dtsx
OnError: 
	Object Type:		 ()
	Description:		
DataFlow Profiling enabled: False
Package version: 1.0.73
...Done.

Waiting for package execution to start...

Package has configurations support enabled: True
Package references and tries to use 1 configuration(s):
	Configuration 1: C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\configuration.dtsConfig

Loading additional configurations specified in command line...
...Done.

Configuring package with commandline-specified values...
	\Package.Variables[User::CustomerId].Properties[Value] = 0
...Done.

Executing...

Package start

Connection Managers used in package:
	Logging: Data Source=localhost;Initial Catalog=LOG_700;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
	Test Package 2.dtsx: C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\Test Package 2.dtsx

OnError: 
	Object Type:		 ()
	Description:		
OnError: Execute SQL Task
	Package Name:		Test Package 2
	Task Type:		ExecuteSQLTask (Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91)
	Description:		Execute SQL Task
	Object ID:		{F96240B8-874F-4D75-8247-070971188D3B}
	Container Name:		Test Package 2
	Container ID:		{C4DB020F-3D99-4D21-93C2-B30FEB890C7C}
	StartTime:		02/01/2009 14.59.57
	EndTime:		02/01/2009 14.59.57
	Message:		Executing the query "SELECT 1/0" failed with the following error: "Divide by zero error encountered.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

	Variables:
		\Package.Variables[User::CustomerId] = 0
		\Package.Variables[User::Package2Var] = 2
		\Package.Variables[User::CustomerId] = 0
		\Package.Variables[User::Other] = Test
		\Package.Variables[User::PackageToRun] = C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\Test Package 2.dtsx
	Expressions:
		\Package\Execute SQL Task.Properties[SqlStatementSource]: SELECT 1/0
	Properties:
		\Package\Execute SQL Task.Properties[BypassPrepare]: False
		\Package\Execute SQL Task.Properties[CodePage]: 1252
		\Package\Execute SQL Task.Properties[Connection]: localhost.Northwind
			\Package.Connections[localhost.Northwind].Properties[ConnectionString]: Data Source=localhost;Initial Catalog=Northwind;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;
			\Package.Connections[localhost.Northwind].Properties[CreationName]: OLEDB
			\Package.Connections[localhost.Northwind].Properties[Description]: 
			\Package.Connections[localhost.Northwind].Properties[ID]: {95BEA08E-1DF8-4F4F-88B4-A87A9A52E219}
			\Package.Connections[localhost.Northwind].Properties[InitialCatalog]: Northwind
			\Package.Connections[localhost.Northwind].Properties[Name]: localhost.Northwind
			\Package.Connections[localhost.Northwind].Properties[Password]: *** WRITE ONLY ***
			\Package.Connections[localhost.Northwind].Properties[ProtectionLevel]: 1
			\Package.Connections[localhost.Northwind].Properties[RetainSameConnection]: False
			\Package.Connections[localhost.Northwind].Properties[ServerName]: localhost
			\Package.Connections[localhost.Northwind].Properties[SupportsDTCTransactions]: True
OnError: Execute SQL Task
	Package Name:		Test Package 2
	Task Type:		ExecuteSQLTask (Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91)
	Description:		Execute SQL Task
	Object ID:		{F96240B8-874F-4D75-8247-070971188D3B}
	Container Name:		Test Package 2
	Container ID:		{C4DB020F-3D99-4D21-93C2-B30FEB890C7C}
	StartTime:		02/01/2009 14.59.57
	EndTime:		02/01/2009 14.59.57
	Message:		The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.). The Execute method must succeed, and indicate the result using an "out" parameter.

	Variables:
		\Package.Variables[User::CustomerId] = 0
		\Package.Variables[User::Package2Var] = 2
		\Package.Variables[User::CustomerId] = 0
		\Package.Variables[User::Other] = Test
		\Package.Variables[User::PackageToRun] = C:\Work\SSIS Logging\DTLoggedExec\TestPackages\TestPackages\Test Package 2.dtsx
	Expressions:
		\Package\Execute SQL Task.Properties[SqlStatementSource]: SELECT 1/0

Package end

Total warnings: 4
Total errors: 4
Elapsed time: 1,1875 secs.
...Package Executed.

Result: Failure