Thanks OPC.three! I will give it a try and will post back whether this worked or not.

Thanks,

Puja

Its working fine. Was using wrong source path variable. Also have added SQL service account and agent account as admin on local drive.

Thanks once again!

Thanks Phil for quick reply.

E: drive is local to SQL box. Gave path as \\servername\e$\Import

Still not working 🙁

-Puja

Thanks ALZDBA for help !!!

Will this command do ?

GRANT EXECUTE TO User_name

ALZDBA, Thanks for help.

Following command worked:

GRANT EXECUTE ON SCHEMA::[dbo] TO user_name

-Puja

Error message:

The EXECUTE permission was denied on the object 'getReportDetails', database 'reports', schema 'dbo'.

SP ddl:

CREATE Procedure [dbo].[getReportDetails]

(

@InstId as BigInt

)

AS

Begin

set transaction isolation level read uncommitted

Set Nocount On

DECLARE @Template_id INT

SELECT RI.Inst_id...

Thanks Welsh....

You were right, it was permission issue. Package was being executed from "C:\Users\pujashah\Documents" location, that have limited permissions.

Thank you again for Help....

-Puja

Thanks Welsh for quick response...

I am executing the script from sa (SQL authentication).

Can you please tell me what permissions are required for an sa user to execute xp_cmdshell ?

One more...

Hi all,

Thank you very much. I liked your suggestions & different but better solutions.

Regards,

Puja

Thanks Mike for new approach. 🙂

Thanks Kailash Mishra.

The query that you gave will give result in an alphabetical order instead of the order in which the roles were assigned. The article is about retrieving delimited...

Hi,

You will get help from this link:

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

Regards,

Puja

Thanks for the help.

I got the solution. I've used a different dataset to calculate the percentage with respect to group.

I've using two datasets:

FiscalData and NetSales

FiscalData contains the fields that i...

Hello JWIDM,

your assumption is correct about "data", it is a field in table. I've attached excel file.

Hope it is understandable.

Net Sales,Total Payroll, Advertising and Operating Expenses are groups and Sales1,...