Recent content by EE02757

Hi everybody, I have a problem and I would like to ask the community to help me... I have a dts using 2 connections: 1 on SQL Server 2000, 1 On Db2 (reached by SQL Linked Server) To sum up the dts takes some data from db2 and put it on a Sql Server's db. During the process in order to know...

Hi everybody, i would like to have help to understand a data type properties i have seen on a Transform Data Task. I precise that i am not american or english so it is more difficult for me to understand... I have a dts (made by another guy) that put data from a table on a file text. The...

Hi mutley1, may be i wasn't clear... i didn't want to know what is the best way to read DTS failed logs but want to realize a dts that would run the week-end to know what exactly happened during the last week. When a job fails you can do this operation to see step detail can't you ? : -...

Hi everyone, i'm trying to find on our Sql Server database where i could find the table that contains error messages when a job fail. I give you know an example : OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart...

Hi everyone, I have a problem with a Step on a DTS where i would like to copy the content of a table from a tablespace to the same table on another tablespace. I've tried with a Transform Data Task to make a "select" of the columns i want, then in the destination i chose the table of the...