In my case this was caused due to the following properties

[Data Flow Task]

DefaultBufferMaxRows

DefaultBufferSize

[SQLServerDestination]

MaxInsertCommitSize

You need to play around with those three parameters and get the correct values for your hardware/software/database configuration....

Didn't realise 1 table and 2 views = 1 trillion tables. Looks like I'll just have to stick with what I have.

OK, I will try but here's my problem (and I'm hoping you can suggest a solution!).

The reason I use views is because the views bring back values that are...

I didn't actually simplify the CREATE VIEW statement. But you're right, the objects used to apply user permissions within the view are views as well. What I'm trying to understand...

Thanks for replies all.

Yes - there are some users who will get all the rows returned.

Unfortunately I can't avoid the view. Our of the three base tables involved two...

Sorry, that was my mistake! I attached the wrong file. Here's the correct one.

Also I changed the view back to it's original format. The ~20 second query time was only...

Thanks Ninja!

While playing around with the SQL for the view I found that if I change the SQL to what's shown below the SORT operation disappears and the query runs...

Sorry but how do I upload the execution plan? I can save it as a ".sqlplan" file or as an XML file.

Thank you for the reply Lowell.

I think I should clarify - the SQL Logins are purely intended to allow a limited number of "privileged" users to access to database via...

In case anyone is interested, this question was answered here:

http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9592e405-75b6-4012-b91d-5af1790ce6d6

...or to put it more succinctly "how long is a piece of string?"

🙂

Sorry I couldn't resist!

I'm no forum expert but surely you can't expect a decent answer if you...

I think this is what you need:

SELECT salesproductkeyid,

actualunitprice,

billdatekeyid,

productkeyid,

...

To get the "instance" name you can also do:

select @@ServiceName

Could it not be to do with the permissions of the user who runs the TaskKill when you execute xp_cmdshell? I think by default SQL server services are started using...

I completely agree with this! Although if you don't have the right personality hopefully you'll be good enough at the technical...