You can directly type the destination table in the OpenRowset property. You can try with myDatabase.mySchema.myTable, but I can't garantuee it will work.

Would you mind sharing those rules?

Try to get your hands on Itzik's book Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions. It has a few solutions for the "gaps and islands" problem.

With different resultset, do you mean different columns? Because that won't work in SSIS. The metadata in the dataflow is static, to ensure high performance.

A uniqueidentifier (GUID) contains text, so it's only logical that you cannot convert it directly to an INT.

What you can do is create a mapping table. Generate your GUID and...

You can post images as an attachment of your post. When writing a reply, scroll to the bottom of the window to post options. There you can upload attachments.

Regarding your...

I guess SpaceID from the first SELECT is the same as ContactID?

Do you have any rules to determine if a datafield is a phonenumber, an e-mail, a pincode, ...?

Easy one 🙂

*nitpicking mode on*

The question should ask "logical processing order", as the optimizer can throw things around in order to get better performance, as long as the result is...

Jeff Moden (7/23/2012)

---

Someone just gave me some incentive to study SSIS. It's called XML SOURCE. Yes, I've already (recently, in fact) written some T-SQL to do something similar...

I'm not 100% sure, but I don't think the checkbox for Enable Package Configurations needs to ticked in order to specify a config file in a job. I'll have to...

You still can use the same method, but you need to disable package configurations and rely solely on the configurations specified in the SQL Agent jobs.

First of all you should take a look at your environment when the timeout occurs. Is the netwerk down? Did one of the servers crash? Is another process eating away...

It seems that you got timeout issues? Busy server? Network latency/issues? It could be a lot of things that cause this issue.

Selected the right answer, then changed my mind. Damn you Monday!

Jeff Moden (7/22/2012)

---

Between what I've seen on the forums, in articles, and what I've seen co-workers go through, I'm going to have to chant for about a month before I...