Below is the stored procedure that I am using to pull the data. You will see that I am currently using row_num to do the chunking. Could I use bcp...

Ok. I have uploaded the current execution plan and the index and table definition. I appeeciate any help. Like I said in the previous post if I only use the...

Here is the function that is being used:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[DelimitedSplit]

--===== Define I/O parameters

(@pString VARCHAR(8000), @pDelimiter CHAR(1))

RETURNS TABLE...

Nothing peculiar at all in the job history. It actually has failed 2 days in a row now. Then we restart it and it works fine. Could it possibly be...

It is being ran through a SQL Server Agent job. I can re-run through BIDS put I can't re-create the error. I received it last night and restarted the job...

I mean SSIS Pacakge, I apologize. The error log does not state was task generated the error and yes this was the only error I received.

That was it. Thank you very much.

Can I create a SSIS Pacakge that willl run a Stored proc that I can pass parameters to? Thanks

I will take a look at the link. Thank you

Thank You. I will get back with all of your answers. For starters it is a physical box and it has 128GB of RAM.

Thanks. I am going to see if this works.

Any idea how this could be accomplished in Sharepoint? Sharepoint is where the reports are being ran from. Thanks.

Ok, so I was able to show/hide the objects in the page header. Is there a way to not export the page header when I export to excel? Even if...

Am I able to do this with the entire page header, if so do you know what the visibilty property of the page header is?

I would never hit the 1 million row count limit. I am just trying to find a way to export this data to excel or .csv. Thanks