Login    Forum    Search    FAQ   Blog

Board index » Server Side Development » ASP 3.0




 Page 1 of 1 [ 2 posts ] 



Author Message
 Post subject: Help Pls
 Post Posted: Sun Nov 22, 2009 10:15 pm 
Offline

Joined: Sat Feb 21, 2009 1:14 pm
Posts: 54
Hello!! every one

i need to export a result set(Sql Sever 2005 DB) 2 excel sheet nd thn end
the mail wid dis particula attachement 2 da people at a specific time
as a AutoMated way.this was what i want 2 acheieve it.

as of now i m doing it as a manual way like

copyin da data 4m the dataabase and thn pasted it in the excel sheet nd then
then mailed with this attachemt to people at a specific time.this has to be acheived an automated way.

Kindly help me to achive it.


Top 
 Post subject: Re: Help Pls
 Post Posted: Sun Nov 22, 2009 10:16 pm 
Offline

Joined: Sat Feb 21, 2009 11:06 am
Posts: 1794
Hi,

I do not know if this could be really feasible for you but, you can do this using SSIS( SQL Server Integration Services ). You need to develop an SSIS package where in you specify the tasks such as,

1. Generating the report

2. Sending mail

Visual Studio BI is used to develop the SSIS package. After this the package can be exported to SQL Server and then can be scheduled to run just like a job.

A couple of links,

1. Generate report (http://officewriter.softartisans.com/of ... r-409.aspx)

2. Send Mail (http://www.mssqltips.com/tip.asp?tip=1731)

Hope this helps!


Top 
Display posts from previous:  Sort by  
 
 Page 1 of 1 [ 2 posts ] 




Board index » Server Side Development » ASP 3.0


Who is online

Users browsing this forum: No registered users and 1 guest

 
 

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron