Please don't crosspost. It wastes peoples time and fragments replies.

Original thread with responses can be found here:

http://www.sqlservercentral.com/Forums/Topic1057264-391-1.aspx

If I understand your question correctly, you have two (easy) options:

* triggers

* UPDATE CASCADE

You can also write a second UPDATE statement in your application logic, that takes the updated IDs...

You can retrieve the packages names fairly easy by querying the MSDB database, if they are stored into the SQL Server database or in the package store.

If they are stored...

Difficult question, but surely nice to know. Good work Andy!

Regarding the speculations about the correct answer being False, read the following BOL page:

http://msdn.microsoft.com/en-us/library/ms141682.aspx

At the section Understanding How Package Configurations Are...

jeff122877 (2/1/2011)

---

+1 for Kimball SCD. However, there are times when you can still use the standard SCD component that is default in SSIS. For example if your dimension...

What you are looking for is a T-tool, not an ETL-tool 😀

I mentioned batch files, because they can just as easily move files, but of course they lack flexibility.

Here's the...

X64 is for 64-bit machines, ia64 is for machines with Intel Itanium 64-bit processors, SDK is the software development kit.

So I would take the first one, unless you have a...

nsg 16606 (2/1/2011)

---

Thanks for the info Koen. I shall down the express edition of sql right away.

So if Sql and Oracle are rival platforms, can I install both on...

http://msdn.microsoft.com/en-us/library/ms141715.aspx

But as steveb already suggested: forget about this component. The bad performance will kill your package.

Create a set-based dataflow yourself (there are plenty of examples on the internet) or use...

What do you mean with targeting?

If you mean read out data, then yes.

If you...

Does setting the property FailParentOnFailure of the executables to False help?

tooba111 (1/31/2011)

---

Hi guys,

Please guide me what is the best and easiest way to transfer package from one server to other. I create a package for my client now...

http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/Features.aspx

Is...

According to this resource, you can't install Enterprise Edition on XP:

http://msdn.microsoft.com/en-us/library/ms143506(v=sql.90).aspx

You can however install developer edition (the same as enterprise, but for development purposes) or Express Edition (free light-weight version...