Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2008-12-10 : 02:05:23
|
| hello i make global variable in activex like sfile="d:\FILE.txt"and it go to dynamic properties ,there i define it as value to FileAttachments.cause every day the mail need to send it.the problem,when i open gmail i saw in the file all the path (d:\FILE.txt) and i want just File.txt.i hope that i am understood?!thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 02:18:28
|
| Use substring function to strip off only filename part from full path |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-12-10 : 03:33:21
|
| where use substring function?in "dynamic properties Task",there i use a global variable (d:\FILE.txt) that get from activex?(global variable go to attachments for "sen mail task") |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-12-10 : 04:43:28
|
| i check it,i use a query in a "dynamic properties task" and wrote SELECT substring('d:\File.txt',4,8),but in attachments in "send mail task" show File.txt,and he didnt find it cause he need d:\.(i remind that i want to send the file without d:\)thanks |
|
|
|
|
|
|
send mail with dts 2000