[quote-0Why do you want to store the TrackingNumber in more than one place?[/quote-0]

They are actually only stored in ConsumableOrderDetail. The temp table that I am using receives data from an...

TrackingNumber in ConsumableOrderDetail is NULL before the Update. The table to be updated will always have an equivaltent number of rows for...

Thank you for your response. The row that gets updated is arbitrary as long as the distinct TrackingNumbers are paired up with the correct TicketID. In the example where I...

As in using a Derived Column transform to remove the quotation marks and parse the data?

Never mind on this. It turned out to be a problem with the SQL Statement. I should have had it set up as follows:

EXEC dbo.FirstNamesUpdate ? OUTPUT, ? OUTPUT

Thanks for your help!

CSDunn

The results that come back from the query represent form information that is filled out online by 'Agents'. Each agent is expected to have a certain number of 'Outlets'. The...

It looks like using the same connection manager (RetainSameConnection = True) between the very first Execute SQL Task in the sequence container (the one that issues BEGIN TRANSACTION) and the...

More information on this problem:

--The problem occurs when I run the package in BIDS on a Windows XP machine.

--The database resides on a different server. The database runs on SQL...

Thanks for the responses. Neither of these scripts will work because Florence 'N' comes back with NorthHampton 'N'. Since Florence has a 'P' associated with the ZipCode, then the script...

There is not, but in the particular case of County/State, No U.S. State has two counties by the same name. I think the update statement would have to be something...

Thanks for your help! I am also trying something with the SQL Server 2005 'Ranking' function.

CSDunn

Thanks to all for your help, and sorry for the lack of detail. 'Crunch time' got the best of me.

cdun2

I tried it like this:

SELECT...

The following is a larger sampling of the results:

ABEARDENWF99

ACHEATHMKS53

AHERROD WB36

ALONG KL65

ALONG KP35

AMGRANT...