SQL Server Performance Forum – Threads Archive
Execute exe file
HI1)Can I execute a vb.net exe file from DTS package?
2)Can I capture email id’s from an incoming Excel file and send SQL Mails to those id’s upon successful completeon of DTS task. Thanks!
"He laughs best who laughs last"
1) You can. There is a task named "Execute Win32 process task" or some similar name that will do that. <br />2) Sorry, fortunately don’t deal that much with DTS.<br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’
‘ />]<br /><br />–<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />
quote:Originally posted by Reddy
HI
2)Can I capture email id’s from an incoming Excel file and send SQL Mails to those id’s upon successful completeon of DTS task.
you can transfer Excel file email to Table and then send an email. —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Dinesk can u be more clear for me.How can I do tht? Thanks!
"He laughs best who laughs last"
]]>