Check out the following thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/3c1605e6-8fb3-4e7a-ab6c-3e99017529f4

😉

Ah yes, property configurations. I forgot about them 😀

In the next version of SQL Server (Denali), this issue will go away. Handling Execute Package Tasks becomes a lot easier.

Nice question, thanks. 3 points w00t!

Regarding the debugging as a whole problem:

SSIS doesn't really support debugging/building a project as a whole. It is just an illusion 🙂

In SSIS 2005 and 2008, the basic unit of...

This is how I do it:

design your child packages and deploy them to the server.

Design your parent packages, set up the Execute Package Tasks and point to the child packages...

I also expect no significant troubles.

BIDS 2008 R2 is the same as BIDS 2008, so everything should be compatible.

The SQLServer service runs under a specific...

Your explanation is very confusing. You should get your syntax straight.

If you want to do some transformations on the table, create a new dataflow, use that table as source for...

So you have data in one table, you want to manipulate it with TSQL and put the results in another table.

I would use an Execute SQL Task.

Oh yeah, I forgot to mention:

SSIS holds the world record for fastest ETL.

Just saying 😀

You really don't get the concept of spamming,...

What is a table named query?

I only know about named queries in SSAS, so I'm not sure what it has to do with SSIS.

Maybe the problem isn't SSIS's fault.

How is the package created? What connectors did you use?

Did you do any transformations? Did you incorporate parallellism?

SSIS 2008 is also a bit faster. This...

Congrats!

SQLMyFriend (5/3/2011)

---

Thank you, but a little bit confusing about below,

when you say, "the only variables that matter are those in the SSIS package itself."

But the variables in dtsconfig matter too,...