| Author |
Topic |
|
cengaver
Starting Member
34 Posts |
 Posted - 2009-07-08 : 06:05:10
|
| hii need sql program that makes data transfer to excel from sql and after transfer it will send mail finally will delete excel..how can i do it?please help me.my mail adress is omer_yalcin1985@hotmail.comthanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-08 : 06:50:03
|
| Use SSIS to put the data into excel and use dbmail to send the file once created.P.S. I am not sure if you want loads of SPAM or not, but if you don't, i'd quickly remove your email address from your post. |
 |
|
|
cengaver
Starting Member
34 Posts |
Posted - 2009-07-08 : 08:22:43
|
| i need to do it with dts.do you have any documant about it or if you know can you help me?thanks |
|
|
|
cengaver
Starting Member
34 Posts |
Posted - 2009-07-08 : 08:44:44
|
| thanks for your helpif you send me code of it i am pleasure so much |
|
|
|
rohitkumar
Constraint Violating Yak Guru
472 Posts |
Posted - 2009-07-08 : 09:03:40
|
| http://support.microsoft.com/kb/319951 |
|
|
|
cengaver
Starting Member
34 Posts |
Posted - 2009-07-08 : 09:41:54
|
| thank you very much buti need codes about it |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-07-08 : 10:24:47
|
| Why? The link tells you everything you need to know. Stop being lazy and actually read it.Do you expect other people to always write your code for you? |
|
|
|
cengaver
Starting Member
34 Posts |
Posted - 2009-07-09 : 08:19:28
|
| i am new in sql and i have to do it in several days. now i am studying sql server but i cant do it until several days so if you help me i will be happy |
|
|
|
cengaver
Starting Member
34 Posts |
Posted - 2009-07-09 : 08:22:41
|
| also i know c# but my boss wanted me with sql..i am really studying to learn sql just i need to more than several days |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-07-09 : 08:25:50
|
quote:
Originally posted by cengaver
i am new in sql and i have to do it in several days. now i am studying sql server but i cant do it until several days so if you help me i will be happy
I answered it herehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926MadhivananFailing to plan is Planning to fail |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-07-09 : 08:41:05
|
| dont think you need to know that much sql with the post from rohitkumar it has a step by step guide, are you saying that really you just want someone to do your work for you |
|
|
|
|
data transfer from sql to excell