I don't know where the issue is but when I was learning about these I would put a script control inside the ForEach container and examine the variable data by...

Use the IP address.

10.1.1.1/Servername for names instance

or

10.1.1.1

This is an example IP address ping to find the real one

I have had issues with that as well. I find it is easier to write a quick SSIS package.

Take a look at your antivirus, some of them scan all of the temp files heavily and cause vary bad peformance.

Try using the IP address of the machine the AD server may not be mapping the name correctly.

You are right about the 2 guids of course that is a habit to assume one of them came from our mainframe where they are stored as strings so we...

How can you be joining a uniqueidentifier to any other data type? They will never match.

SELECT Users.Email

FROM Users usr

LEFT OUTER JOIN EventParticipants prt

ON CAST(prt.ParticipantID as char(36)) = CAST(usr.UserId ...

Unless you are doing a one time load where you can use SSIS fuzzy matching. You are going to need a rule such as split at the first space and...

If these are both uniqueidentifiers you have to convert them to (var)char prior to matching them.

cast(1.id as char(36)) = cast(1.id as char(36))

With 2000 the reules are the same but applied differently:

1. Create a table variable to insert to org data

2. Add this table to the join

2. Add the information table to...

I am looking at your where clause "where o_id in (1, 2)". If this eliminates a lot records it would make sense to use a common table expression to extract...

I couldn't get anything but an "n/a" on the sequence number export so I simply made the sequnce column of the table auto increment and eveything worked fine.

Alan

Nice article.

The DELETE was the trick for me as well as the BIG INT. This will be useful to our virtualization managers as the block sizes seem to have...

char(1) should should be correct since it will always have a value. Using char(1) will place the always present data at the front of the table in the non-variable data...

What is running the package? The point is just because you can log into the SQL Server does not mean the windows domains are going to allow you to connect....