It has gotten a lot easier with Powershell.

In the past I have used scripts to write FSO in ActiveScript Code (DTS) to search for certain files based on date, then...

sol.nt (7/17/2011)

---

hi ,

Because i'm still thinking about this problem and don't come up...

If you look at look how much the cost you are going to cost the customer for your "man Hours" and the cost of memory and the fact that you...

Just to clarify this is happening on the test system.

I did not want to say it but I would get some memory. It is not that expensive and you spend more money in hours than it would cost to...

lostdisk (7/18/2011)

---

This has only started to become a problem more recently, and one thing we have done is reallocated the amount of memory from 16GB/16GB to 24GB/8GB....

According to Tara Kizer

Microsoft MVP for Windows Server System - SQL Server

In reference to a Microsoft Article, says "Ignore what it says about 64-bit. It is absolutely needed on 64-bit....

Sorry, I double checked and it appears that locking pages in memory is not required on 64-bit operating systems.

I'm not sure but I will try and find something.

Ah, so we have a smart A#UY$ in the crowd , eh?

I don't know if any of these are relevant to your situation.

http://stackoverflow.com/questions/1537812/there-is-insufficient-system-memory-in-resource-pool-internal

https://connect.microsoft.com/SQLServer/feedback/details/484787/there-is-insufficient-system-memory-in-resource-pool-internal-to-run-this-query

http://support.microsoft.com/kb/982854

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=152533

ringovski (7/18/2011)

---

I am adding the code to package flow I have designed that will be added to a SQL job so it can run automatically everyday. I tried doing it...

You don't want to use a comma. If there is a comma in any of your columns your transformation will fail.

Try using a pipe | or some ASCII Code...

SQL Script to check blocking and blocked processes.

http://sqlserver-training.com/sql-script-to-check-blocking-and-blocked-processes/-

To check for Index Rebuilds it would normally be a job. You could also check the processes and the statements that are being...

Is your Excel File Template? It not start with a clean sheet for it could possible throw that metadata error.

viduvs (7/18/2011)

---

I am using an SSIS package to export more than 300000 rows in excel (.xlsx) from SQL Server.

I am using query with the columns having data type nvarchar and...