"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:OFof%23ZfZFHA.2996@TK2MSFTNGP10.phx.gbl...
>I have added another Destination to my DTS package (it is a different table
>in the same database). Now the DTS package isn't working as expected.
>
> It now loops through the query, picks up the ExcelLink and executes the
> 1st transform, then loops back, when the loop is finished, then it
> executes the 2nd transform. Therefore, the 2nd transform isn't looped, so
> only some of the data is inserted.
>
> How can I reorder this so that both the transforms are executed at the
> same time (or at least before the loop comes back around)... or I could
> just have the DTS package run a SP at the end of the package that copies
> all the data in one table to the other.
>
> Thanks,
> Drew
>

"Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
news:%23hxmGbgZFHA.3864@TK2MSFTNGP10.phx.gbl...
> Here is some more info that I have found in working with this problem. I
> added MsgBox's to Begin Loop, Both transforms and Loop Around. This shows
> me what the path to the Excel file is.
>
> The problem seems to be that the loop runs fine until it gets to the end
> and then it performs the 2nd transform again (using the last Excel path
> that was used). This enters duplicate data into my database.
>
> Why would it run the transform after running the loops?
>
> Thanks,
> Drew
>
>
>
> "Drew" <drew.laing@NOswvtc.dmhmrsas.virginia.SPMgov> wrote in message
> news:OFof%23ZfZFHA.2996@TK2MSFTNGP10.phx.gbl...
>>I have added another Destination to my DTS package (it is a different
>>table in the same database). Now the DTS package isn't working as
>>expected.
>>
>> It now loops through the query, picks up the ExcelLink and executes the
>> 1st transform, then loops back, when the loop is finished, then it
>> executes the 2nd transform. Therefore, the 2nd transform isn't looped,
>> so only some of the data is inserted.
>>
>> How can I reorder this so that both the transforms are executed at the
>> same time (or at least before the loop comes back around)... or I could
>> just have the DTS package run a SP at the end of the package that copies
>> all the data in one table to the other.
>>
>> Thanks,
>> Drew
>>
>
>