Not sure if this will help you but we also use SQL Jobs to execute SSIS packages. Sounds like it is definitely a security issue... perhaps you need to execute...

You cannot use stored procedures from within a select statement (to my knowledge). Not sure of your requirements exactly but you may need populate a table using the stored proc first,...

I'm not sure if this will help, but if you are going to open the exel files anyway, you could put the calls to the stored procedures in the Excel...

oops, this was a copy of the previous reply... posted twice due to an error in the ASP.NET application.

Unfortunately, SQL Server 2000 has no provision for cross-tab queries. You can still return a pivoted data set but you need to know all of the possible values in the...