My SSIS package extracts data from the database and dumps it into a textfile with timestamps.There is job which runs this SSIS package every hour.I have to mail each of...

Can you plz elaborate on the process.

Thanks

Issue has been resolved.

Thanks

Yes under sql agent . I believe with admin rights....Want to verify about how to check if the sql agent is running this job with admin rights ?

Thanks

Under file system.The package is running on the server .

I asked since UI is not an option as far as I am concerned.

Thanks

Suppose this is my stored procedure

CREATE PROCEDURE [dbo].[usp_test]

AS

select * from emp

GO

How do I export the results to an excel file with the name of the excel file changing every...

How do I check if the proxy user has the necessary permissions / privileges

Thanks

Exactly 1 column(datecolumn).

The output I need from a t-sql query is in this format .

Datecolumn ...

How do I automatically insert commas between the values that come into the OtherColumns column from the 4 checked columns check1 ,check2 ,check3,check4 ? Thanks

Thanks...Thats exactly what I identified and it worked.

No

Error :

[Microsoft][ODBC SQL Server Driver][SQL Server Mail Sent.

[Microsoft][ODBC SQL Server Driver] String or Binary Data would be truncated.

[Microsoft][ODBC SQL Server Driver]The statement has been terminated.

Thanks Mate..that helped !!

Thats where I guess I need some assistance . Appreciate your response .

Thanks