It seems that your keyboard is broken: all your text is accidentally printed in caps.

Google (or Bing) these simple keywords to find your answer:

* SSIS tutorial

* SSIS connection manager

* Execute...

I think it is best if packages do not have the same ID.

It could be related (or maybe not). Change the ID in one of the packages and see what...

Developer 2005 (8/11/2010)

---

Both Question and answer don't have sufficient information about target.

What is the purpose of IDENTITY_INSERT ?

And answer

SET IDENTITY_INSERT allows explicit values to be inserted into the identity...

Excel always screws things...

Is there a question?

OK, this one was too easy 🙂

Great question! It makes you think and it learns you something.

The explanation was very well done.

Good job!

The error indicates that there are some issues with the metadata in your package. Try to refresh it (by opening and closing the component that gives the error).

The book "Professional Microsoft SQL Server 2008 Integration Services" from Wrox has some chapters about creating your own .NET components:

* chapter 18: Programming and Extending SSIS

* chapter 19: Adding a...

In BIDS, you have a tab Event Handlers. In the Executables dropdown, you can choose to which task you want to add an event handler. In the Event Handler dropdown,...

Janie.Carlisle (8/6/2010)

---

I am not sure I understand why that will keep the package from failing. Sounds like it will write the bad record to a table but then fail the...

That is a nice article you are using. But personally, I would create a temp table in the SSIS package and write the update rows to that table. Then perform...

I think we need more information.

What does the package do? Does the package run in BIDS? What errors do you get?

Usually, when a package runs in BIDS but doesn't in...

Not everything in SSIS is done with T-SQL. A better option - for standard components - is to use the error...

Data sources are to be avoided when working with multiple environments.

See the following resource (from MS):

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