Sounds like an interesting option although I am not sure how to do it. What is happening now is the package is going into SAP and extracting data from a...

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

Go in Report Manager. Click on the subscriptions tab. Choose new subscription. Enter the email addresses. Set a schedule. Click OK.

Thanks Guys!

It was not a sproc I wrote and I hadn't spent enough time reviewing the code. Once I added the companyID to the table and the join it worked...

Not sure if you're just trying to get the beginning and end of a month or the day that the month begins and ends on.

CREATE FUNCTION [dbo].[dbFunc_GetFirstDayOfMonth]

( @pInputDate DATETIME...

An easy alternative - depending on your set up - is to go to Report Manager, click on the report in question, view properties/security and it gives a listing of...

The question is how do I reduce what I have now from multiple sprocs to maybe one? There has to be a simple way and I think I get caught...

Dude, you rock! The last time I did that it was an incredibly painful process; detach database; move everything over; redirect and redo indexes; double check permissions; reattach database. This...

Just to be sure this is the best way to go about achieving what I need to accomplish; here's the scenario.

Today, I need to free up space on existing drives...

Thanks Jack! I knew it was simple and for whatever reason [it's Monday] was just having a brain glitch. Worked like a charm. Thanks again.