ChrisDodgson
Technical User
Hi,
I have got a DTS package that exports the results of some SPs to an Excel workbook on a daily basis, because it's a daily job, I've set up a dynamic properties task (to be the first thing that happens in the DTS) and this datestamps the name of the Excel spreadsheet to something like:
\\myserver\myfolder\myworkbook 20051031.xls
However... I've now been asked to set up an FTP that puts this workbook into a second location on a different server, and then to email out a copy to some remote sites that don't have access to our servers.
My problem is that the FTP task looks for a static filename, whereas mine changes on a day to day basis, and, as I understand it, xp_sendmail does the same thing. I have no understanding of VB and am a bit of a dunce, so please use words of one syllable where possible...
Thanks,
Chris![[nosmiley]](/data/assets/smilies/nosmiley.gif "[nosmiley] [nosmiley]")
I have got a DTS package that exports the results of some SPs to an Excel workbook on a daily basis, because it's a daily job, I've set up a dynamic properties task (to be the first thing that happens in the DTS) and this datestamps the name of the Excel spreadsheet to something like:
\\myserver\myfolder\myworkbook 20051031.xls
However... I've now been asked to set up an FTP that puts this workbook into a second location on a different server, and then to email out a copy to some remote sites that don't have access to our servers.
My problem is that the FTP task looks for a static filename, whereas mine changes on a day to day basis, and, as I understand it, xp_sendmail does the same thing. I have no understanding of VB and am a bit of a dunce, so please use words of one syllable where possible...
Thanks,
Chris