Having SQL Server and your Web Applications is a big security risk...

Is this the production environment?

Why are you returning 59K records?

Are you calling the Web Application from your local PC?...

Are you only having this problem with this query (datasource)?

What happens if you export the results of a small table from one of the sample databases?

What happens if you simplify...

Is this an internal or external Web Application?

It is recommended to have separate DB & Web Servers.

I assume that you examined your project in BIDS?

Have you tried creating a log file?

You mentioned that you went into debug mode, I assume that you set breakpoints?

Double check the properties on your flat file connection manager...

What OS's are used on the DB Server and Web Server?

How many hops is it taking to go from the Web Server to SQL Server?

What protocol are you using?

Are you...

Thank you Lutz, please accept my apology for not asking for complete information...

It would appear that you answered your own question, way to go bro!

Very well stated Lynn.

Do you have a SAN?

Can you back up to the SAN or local Disk storage. THen you can perform tape backups./

Backing up across the network is going to be extemly...

Go into Single User Mode.

Run the DBCC INPUT BUFFER Command an run a SQL Trace, etc.

Check your DMV's, etc

Regardless, you have exceptional skills and I respect you very much!

Thank you for your feedback.

I will accept the advice of anyone on this issue.

But if you perform a backup to a disk that is not on the same Network Segment...

Gail,

btw, that was an awesome catch on the cluster.

You are exceptional and you amaze me. You are a great asset to this forum.

But I guess that I should tell you...

I completely understand what you are through and I feel for you

Your are fighting a loosing battle.

I try to win over the user base but that puts you at ...