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...

@SSCrazy Eights - thanks for mentioning Fabian Pascal.  I started learning SQL in 2010.  The first book given to me was printed in the mid 1990s.  I cannot remember a...

Yeah...that would help.  Sorry about that!

Navigation Guide Document: https://docs.microsoft.com/en-us/sql/sql-server/sql-docs-navigation-guide?view=sql-server-ver15

SQL Server Guide Page: https://docs.microsoft.com/en-us/sql/sql-server/?view=sql-server-ver15

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 4 years, 8 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

So I bean running with the advisements you both offered on better explaining the docs and getting access to Book Online.

After reviewing the "Doc Navigation Tips" page (see link below),...

Hey Jeff - thanks for the responding!

A long time ago, I taught high school math.  Before my first teaching assignment, a professor suggested that I review a standard geometry textbook...

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...