How to use DTLoggedExec

Executing DTLoggedExec¶

DTLoggedEXec is a console only program, so all you have to do to use it is just invoke the DTLoggedExec executable from the command line. If you have installed the program as suggested in the Download and Install page, this is how your command like should look like:

c:\DTLoggedExec\Any>DTLoggedExec

If you want to have an help on all the parameters you can use, just execute DTLoggedExec with the parameter "/?" to have a list of all variable parameters.

c:\DTLoggedExec\Any>DTLoggedExec /?

You can find detailed information on the usage of all available parameters in the Command Line Parameters page.

Using DTLoggedExec with SQL Server 2005 or SQL Server 2008¶

DTLoggedExec can work with Integration Services shipped with SQL Server 2005 and with Integration Services Shipped with SQL Server 2008. To run DTLoggedExec using SSIS from 2005 you don't have to do anything. DTLoggedExec will simply work.

If you want to use it with SQL Server 2008 you just need to copy the file "DTLoggedExec.exe.config" the you can find in the "For_SQL_Server_2008_Compatibility.zip" file under the DTLoggedExec folder in the same folder where the executable you're using is placed.

This config file simply contains the information that the .NET Framework needs to have in order to be able to use the new version of SSIS Engine, binding to the correct assemblies.

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
        <dependentAssembly>
          <assemblyIdentity name="Microsoft.SqlServer.ManagedDTS" publicKeyToken="89845dcd8080cc91" culture="neutral" />
          <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0"/>       
        </dependentAssembly>
		<dependentAssembly>
			<assemblyIdentity name="Microsoft.SqlServer.DTSPipelineWrap" publicKeyToken="89845dcd8080cc91" culture="neutral" />
			<bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0"/>
		</dependentAssembly>
		<dependentAssembly>
			<assemblyIdentity name="Microsoft.SqlServer.DTSRuntimeWrap" publicKeyToken="89845dcd8080cc91" culture="neutral" />
			<bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0"/>
		</dependentAssembly>
	</assemblyBinding>
  </runtime>
</configuration>