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 |
|
sardinka
Posting Yak Master
142 Posts |
 Posted - 2005-02-01 : 08:45:22
|
| In activeX I have the following VBscript.Where I getting the filename and location from Connection Source.I need to add the date to the file name by using the code below the dateis adding at the end of the file name after .txt. I need to add before the .txtto look like that \\filenamedate.txtHow do I do this?Set oConn = oPkg.Connections("Text File (Source)")sFilename = oConn.DataSource & Day(Now() ) |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-02-01 : 20:26:56
|
try:sFilename = replace(oConn.DataSource, ".txt", Day(Now() & ".txt")Corey "If the only tool you have is a hammer, the whole world looks like a nail." - Mark Twain |
 |
|
|
|
|
|
FileName