Yes, if I go the Properties on that connection, there is a value "Maximum Number of Records to Retrieve" which defaults to 1000

For the record, I had actually found that...

Is there not a big difference in speed between FastLoad and "Table or View"?

I am experiencing a problem with the same error message but I am loading ~100 million (fat)...

I am not surprised you answer that... but it's a bit difficult to give more details precisely because there might be so many factors.

Today we ran some tests that (so...

Not entirely but I feel less alone now! 😀

Thanks

Interesting...

This only seems to affect the debugging via BIDS.

When fired through SQL Server Agent or DEXECUI, it seems to behave as expected.

Maybe by configuring my package on the fly in...

Well... Here is what I did if anyone is interested...

I stored the location of SSIS Packages at Runtime in some database table and used an Expression to change the value...

Thx! 😀

Hi there!

I was just wondering about SQL Server Performance monitoring tools but we are a very small shop, hence free would be much better!

Since two years passed since that thread,...

Not sure if that helps but I had a similar problem and I seem to have fixed it by changing my stored procedure parameter type from DATE to SMALLDATETIME.

I assume...

I'll try to put some testing, then...

Promise!

Thanks

Similar question... We have a commercial web site using ASP.Net and SQL 2005 back-end.

The web site is usually fairly quiet but experience very big spikes of activity during "sales" (which...

I suppose I could.

If I have to modify my package, I might even be tempted to simply store the configuration database connection string as a variable and pass the variable...

Actually, this is not a bad idea!

I installed 3.0 as a standalone app and it works...

For once, it does not appear to be the culprit...

I disabled it, rebooted... and found the same problem again.

Nop but I agree it sounds like this.

UAC and I are not in good terms... :ermm: