What I mean by the former suggetion is to change the logical structure of your package so that the tables are dropped, then the constraints are applied (application of constraints...

I assume the data loaded but the application of the constraints failed?

You can either apply the constraints before inserting the records and then divert errors to another destination (table if...

Thanks for the link, I shall have to add that error handling approach to my list of favourites 🙂

I wonder if some settings might cause locking issues; probably only with...

IIRC, when a destination is set to use bulk operations the data loads in batches and any errors cannot be handled individually. You would have to turn off bulk operations,...

EncryptSensitiveWithUserKey

Uses a key that is based on the current user profile to encrypt only the values of sensitive properties in the package. Only the same user who uses the same...

Yes, as has been explored there are very few options with the JET driver (don't know about the ACE driver). The number of rows read to determine the data type...

Simply, you're going to have to set the filename with an expression. There are other ways but none are 'better' without becoming relatively complex, and all are logic dependent afaik.

If you don't know what it is then you probably don't need to use it; it's for datawarehousing.

And if you do know what it is then you don't want to...

I know more about what can be done with SSIS than what can be done in SQL, so some of these things probably are doable in SQL; but this just...

I've seen that ssis converts text to unicode, IIRC the solution is just that you have to use a Conversion task to explicitly change it to the correct type.

Have you considered using a mapping table?

Rather than hard coding reference data into a query store it in a table. That way you can reuse the same Category logic multiple...

See if this helps: http://beginner-sql-tutorial.com/sql-joins.htm

There is a section on self joins towards the bottom that will help, and it includes aliases in the example for selecting fields.

PS: Under most business...

I still think you're better off altering the packages, but...

Why not try both? My money would be on the 2008 box needing the 2005 client.

This ought to do it: http://msdn.microsoft.com/en-us/library/ms131321%28v=SQL.90%29.aspx

In addition to installing SQL Native Client as part of the SQL Server installation, there is also a redistributable installation program named sqlncli.msi, which can...

They are on separate boxes right? The 2008 and 2005 instances? And the package is executing in the context of the 2008 box?

I would expect that, as described by the...