And this is you solving your problem on your own...

Maybe I'm missing something, but isn't your query the same as saying:

delete from [192.21.10.34].test_DB.dbo.emp_check1 where eid = 12345...

In that case I would build a dynamic INSERT statement using the metadata found in the INFORMATION_SCHEMA tables. Find all the columns for a specific table and create on the...

Is it possible to post the query?

How do you put the data in the tables?

Do you use a dataflow, an Execute SQL Task, a script task, ... ?

Nice article, thanks Tom.

Looking forward to the rest of the series.

I'm with cengland0 here. For ETL populating a data warehouse, I do not use DRI. I believe the ETL itself is responsible for the RI and using foreign keys just...

In Denali this will be easy, but for the moment you can't tell SSIS to ignore the design-time default.

You could set all the connection managers to invalid connections, so that...

This thread should point you to the right direction:

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/b3ff9cf9-c023-4ffc-8dd7-fba9644be441/

There isn't an out of the box XML destination in SSIS.

There are probably some 3rd party components out there, either paying or open-source.

Or you can create your own using a...

To expand: take a look at the Locals window and the Watch...

Well, you solved your...

I still think the problem lies somewhere else. The OLE DB Destination with Fast Load option shouldn't have too many troubles inserting millions of rows. Maybe you can try a...

Koen Verbeeck (7/13/2011)

I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked for!...

Excellent question. I got it wrong, but I definately learned something. And it is very useful to know how the restore will fail.