Need any assistance on this piece or have you found what you needed?

I do not think you need to add anyone to the sysadmin Role for this. Per the article you just need to add the service account you decide to use...

Which service account is the Agent service logging in as?

Per this article in addition to enabling the service you must also change the SQL Server Agent service account and ensure...

Any sorting requirements? If each line in the file could have a different number of fields then what format should each line in the file be in, e.g. comma-delimited, tab-delim...?

Please define "total count of pages."

It sounds like you are looking into writing a package that will something very similar to what redgate SQL Data Compare tries to do.

Can you please clarify these statements:

I need...

Good to know you have a way forward but it seems like a Script Task would be a better choice here to save you a round-trip to the database server...

Espresso

Attached is a sample SSIS 2008 R2 package that pops a MessageBox for each database on your instance.

It's the Database!!! (2/18/2013)

---

opc.three (2/15/2013)

---

1. Create 3 Variables

- one of type Object that will contain the list of databases

- one of type Int to contain the database_id

- one of type...

What you're experiencing is one of the frustrating pieces of Ownership Chaining. A DENY is not respected when an Ownership Chain is in play because only the highest chain in...

If it's a heap, see my...

Use of XMLReader is an iterative approach so you'll be writing code with the structure "for each node in document, do something" and those for each statements can be nested....

I can tell you that variables based on expressions do change when they are used but the "used" part is a little murky. The loop coupled with the waiting that...

Or is you just want to know the total memory used, like what you were looking for in Task Manager:

SELECT cntr_value AS [Total Server Memory (KB)]

FROM ...