HI,

I have a DTS package SQL Server 2000 that I have convert into SSIS for SQL
Server 2005.

The conversion have Embedded my DTS into a package
I did some coorection and the SSIS is now working
Soon as I execute this SSIS in a job the SSIS dont work anymore

This SSIS use an ODBC connection to read data in a accpac file on another
server
I would like to log the path of the ODBC connection that the job use because
it happens in the pass that some caracter in the connection string are
replace by another caracter so I would like to verify this.
By changing those caracter it make the job fail!

That strange behavior happens only when the job execute the SSIS

How can I log or see in a dos windows everything that the job execute
I try to use a trace in the profiler but I dont see any path from the ODBC
connection

I am not experiemeted in using Profiler so maybe this is the tool to use but
is there a special way to use it

Thanks in advance and have a nice day!



Is there a way