I have create a SSIS package .Now i m trying to schedule this SSIS in sql agent jobs.

but i m geeting error. unable to run it.

pls. help me how can...

Hi ,

I have tried this but didn't get how to use it.

i want to generate multiple excel sheets , date wise.

can i do this through TSQL.

pls. guide me.

urgent.

hi,

thanks 4r reply.

i want to know , how can i export the sql server query result to multiple excel sheets.

through sql jobs. i can do thid with openrowset on single...

Hi,

I have a select query and want to pass the result of this query to excel sheets as per day bases.

i m working on sql server 2005. how can i...

How to export sql server data into multiple excel sheets ?

I don't want to do this from DTS or SSIS. i have dalready done this from OPENROWSET, but only...