Yeah, sounds like the transaction settings are off somewhere.

If this is more of a learning exercise and you have the option to run the package in the IDE, consider this...

Hi there!  If the transformations have to take place in the SSIS data flow, then try the DATEPART SSIS expression (see links below).

The Microsoft document discusses the SSIS expression and...

Phil's suggestion of a permission issue is pretty spot-on.

Consider reviewing the stored procedure for TRY/CATCH statements.  I am wondering if the code is preventing an error from being raised.

Another thing...

• This reply was modified 6 years, 3 months ago by scott.fountain. Reason: The comment I made lended to an assumption. It might be best to keep it a little more open

A very good book! If you do not have a copy, then get one!

Applying indentation so scripts are readable

Nothing spells a good day at work like reviewing a query containing multiple nested table expressions; all the while, no indentations - everything is blocked...

Yes, 70-433 (2008 Database Development) - sorry about that. But yes, it made for an awesome companion book to 70-461.

And while its out of this forum's scope, if someone...

I just took the 70-461 exam and passed.

Concerning the 2012 Certification book, yes, the practice questions there are easier than what's on the exam.

However, with respect to the 2008 Certification...