I'm going to recommend that you read the first article linked in my signature as I don't have any idea how the code you have posted ties to the question...

It's probably me, but I still don't get what you need. You are not including period in your output so your grouping would be on Item and Year so...

Thanks for posting the code. I wouldn't call what is happening a BUG per se, but I would call it a poor design decision. Because you are calling...

Are some emails being sent successfully? How do you know it is the number of connections to your Exchange server that is causing the problem? What else is...

Thanks for posting a test structure. I still have a question though, what is the format of the data you wish to return?

Do you want it just grouped by...

I'm surprised no one asked, but why do you need to shrink it? Will the database grow again? There is a reason it grew to that size and...

Sounds like you are going to need a derived column transform or a script component to manipulate the date to a format that SSIS can understand is a date. ...

I think you need to share your code later in the script. All you have shown here is getting the database list. If you call the inline function...

I don't know much about C++ or SQLExecDirect, but yes the insert and triggers will fire in a single transaction so either all the actions will complete or fail.

What...

Without seeing the data returned I don't know that I can give definitive answer, but I would venture to say that you can probably do it in either place. ...

I'd start with this information:

Server Specs - CPU's, memory, drive configuration, OS, SP level

SQL Server Specs - licensing model (# of licenses), version, edition (standard, enterprise, etc...), SP level, services...

jcrawf02 (10/15/2009)

---

Unless the applications are always going to be inextricably linked, will never be sold separately, migrated separately, etc. then separate them. If they are inherently one thing, and will...

Luke L (10/15/2009)

---

Jack Corbett (10/15/2009)

---

Not big. We are talking, biggest non-audit table is less than 30K rows with maybe few hundred to a thousand added a year.

My biggest issue...

Bob, good idea and will do.

Just for the record I'm a separate 'em guy and I'm the roadblock, or as I like to say the voice of reason.

Not big. We are talking, biggest non-audit table is less than 30K rows with maybe few hundred to a thousand added a year.

My biggest issue is that one project...