Bob already got 95% of it, but here you go:

Abbie,...

OK, makes sense. 🙂

You didn't include the Server & DB names in your list of examples, I am pretty sure that you need to include those in every URN.

AFAIK, you cannot skip the...

Gift Peddie (3/12/2009)

Actually for SQL Server 2005 and up VS2003 is too old you may not get any help from Microsoft if...

Here you go, I think that you'll find that this works much better:

CREATE FUNCTION fnFINDCOLUMNS (@VARBIN VARBINARY(4000), @TableID int)

RETURNS TABLE AS RETURN

Select id, colid, [name]

From syscolumns

Where colid >...

Actually, I came up with an even better way to do it. Hang on while I write it up and test it...

Yes you could make this much faster (and simpler, IMHO) by replacing the outer loop with a join to Tally table to index the bytes and replacing the inner loop...

Ah, Lord Of The Pit was always one of my favorites. I had several decks based around him.

You can, but the syntax is unusual (and undocumented, I believe):

UPDATE AliasName

SET ...

FROM RealName

...

And, as long as we are on the subject, here is a VB.net function that I wrote that generates URN strings for you. I find it very handy for...

OK, it's "Server.GetSMOObject( URN )" to return any object in the SQL Server Instance by its URN. Details are in books online.

I was going from memory and probably misremembered its name. Hang on, I'll look it up in my code...

You client language has nothing to do with what edition you use.

What matters is, what network environment will it be in?...

This should be posted as it's own topic, in the appropiate forum (which is probably NOT Integration Services). When you do, be sure to include the actual error message.

If you are using Lowell's query then just change TABLE1 to "declaration_tax_claim_lines" and TABLE2 to batch_transactions, and take out the extra reference on the first line.