Yes you can send the excel report through an email.

DTS package should look like this:

Server--->Excel---->send email task or use xp_sendmail----> use an activexscript to delete the current excel and place a...

what do you want to update tableb with? can you send a sample output? i dont think i understood your question clearly.

can you explain as to how your input and output will be. your explanation looks as if you want to insert into table b.

do you want to insert the records from table a into table b or do a update? should your output be somewhat like this

ID                              Code

A                                 10

A                                  20

here is the insert...

This query gives the count of user tables and the system tables. Run this query in the database you want to

select count(*) from sysobjects

where xtype in ('U','S')

'U' = user table

'S'...

You can create a DTS package (Server->excel) and schedule the package. hope this is what you were looking for.

Thanks again!!!

Thank you so much for the detailed information.

We have all our servers set up by some other team and they handed over the servers to us. Now the servers...

My understanding is the id and password that i use to login onto the box remotely using the service account should match with the id and password that i mention...

A silly question, sorry about that

once i change the password in the enterprise manager and restart the services, will i be able to remotely login onto the server with the...

Thanks everyone for the replies. so i understand that the steps i have mentioned are correct right? Please let me know.

Thanks Greg. I didnt use it till now. anyway thanks for the info.

hey thanks a lot i got it!! i can see it in the Jobs tab.

Thanks for the reply. does it create a job under SQL Server agent -> jobs folder when we right click and schedule the package

Hi once the exchange administrator tried to send an email to me from that box and i got the email. i am using my email address in the operator