A straight forward,precise to the point answer. Thanks Anthony.

Now, i would install SSIS on all nodes and let the Agent run the SSIS packages through job.

To manage the packages...

I would be running SSIS packages through SQL jobs. In such case, what should i have to do? Dont i need to make the .ini/xml changes.

Yes anthony, I indeed had a look at that. My conclusion is that there are 2 ways

* configure SSIS as a cluster resource

or

* change SSIS config (.ini/xml) file and make...

Am going here and there reading everything that i am confused now

Are the below talking about the same method?

* Configuring Integration Services as a clustered resource

* installing SSIS...

In the meantime anyone out there who can help with the qury

Oh oh... then i would be waiting for the script with bated breath 🙁

Query looks great. But, it missed out one detail. If the job is scheduled to run daily, then it gives the next run only and does not give the day...

does Proxy account exists on those servers?

Anthony,

Yes.. now its clear. Thank you.

The query returns dbo and datareader roles only, all other are coming as NULLS

Yes i tried that.

SELECT MemPrin.name AS MemberName, RolPrin.name AS RoleName

FROM sys.database_role_members a

INNER JOIN sys.database_principals RolPrin ON RolPrin.principal_id = a.role_principal_id

INNER JOIN sys.database_principals AS MemPrin ON MemPrin.principal_id = a.member_principal_id

INNER JOIN sys.server_principals ...

Save the package with password. Use EncryptAllwithPassword in package properties.

Yes jeff, I tried to use EXECUTE AS, but it was a bit confusing, since I dont know whether I should give Agent account or my account in EXECUTE AS.

I am trying to run a query in multiple server. In a SQL server A, I have created linked servers. When i run the query in QA, it runs,because my...

Mike,

We are using sp_OACreate, sp_OAGetErrorInfo, sp_OAMethod, sp_OAGetProperty, sp_OADestroy.

Error occurs only for some of the records which satisfies a particular condition and not for all records. Even though, we get the...