It is just a join of two sorted data sets.

Remember, like everything else in SSIS, it is data-type, case, accent, and trailing space sensitive.

If you can temporarily live with the performance, that is probably what you need to do.

LOOKUP components are not very fast once you get to a lookup table that is...

First, putting the line items in the table as an XML object is a bad idea. There are some uses for XML data (I think), but reducing your relational...

Try creating another Connection Manager to the data source.

Set the "RetainSameConnection" property of the new connection manager to true.

Set the lookups you are having trouble with to this new connection...

First, how did you end up with 12.5gb of memory in a server? 3 4gb dims and a .5gb dim? It is a strange number.

Are you running 32bit...

Here is an article on tally tables.

http://www.sqlservercentral.com/articles/TSQL/62867/

There is code to get a list of dates between two dates using the tally table in the article.

You will then just need to...

You can force a procedure to drop it's plan for each execution with the RECOMPILE keyword.

This is almost always a bad idea though. It can sometimes be ok for...

DBCC DBReindex works on SQL 2005 Standard Edition.

You should no longer use it though, use ALTER INDEX instead - see books online for details.

[font="Courier New"]"Unable to find column NewResultName in the result set.".[/font]

Your result set name on the ExecuteSQL task you are using to set your variable should be "0", not "NewResultName".

For example:

CREATE TABLE #Users (UserName VARCHAR(10))

INSERT #Users VALUES ('Tom')

INSERT #Users VALUES ('Joe')

INSERT #Users VALUES ('Amy')

CREATE TABLE #Dates (MyDate DATETIME)

INSERT #Dates VALUES ('1/1/2001')

INSERT #Dates VALUES ('1/1/2002')

INSERT #Dates VALUES ('1/1/2003')

INSERT #Dates VALUES...

I think that is the ticket.

It sounds to me like you need a CROSS JOIN

Unless you are actually seeing the distributor getting resource-bound, that is what I would recommend.

Here are a few options. Depending on the indexing on the tables, they may perform differently. It is hard to tell with table variables and so little data.

They...

Network configuration would probably impact this heavily. If you have 10 distribution agents and enough bandwidth between your publisher, the distributor, and the subscribers you may see better performance...

SELECT

*

FROM

@vtADRES A

INNER JOIN @vtADRSRT B ON A.adrid = B.adrid

AND B.Type = (CASE WHEN B.Type = 1 THEN 1

ELSE (SELECT MIN(X.Type) FROM

@vtADRES Y

INNER JOIN @vtADRSRT X ON Y.adrid = X.adrid

WHERE Y.naam...