Post reply

Creating an Excel file with variable date

  • November 10, 2005 at 12:26 pm

    #89834

    Hello to all. This is the case. I created a DTS package  (SQL Server 2K sp3(a)) that runs a bunch of routines. The DTS works perfectly. One of the steps is the creation of and Excel file. I did so with no issues whatsoever. I have to e-mail the file every monring to a few folks, also works fine.

    The problem came afterwards, I was using a generic name to create the file, let say ExcelTransfer.xls. Well, the users got so happy with that for a couple of days. Then, they said "we need the file, but can you stick the date for each file to know exactly which one it is? Sure enough, I did so. Here is where I found the problem.

    I created the task to stick the date in the file using a tool, maybe old but works fine, FDate, but when the e-mail is going to be sent out, the system does not recognize the added date automatically. I have to reset the mail step to enable it to send the file. I read somewhere in SQL Server Central a way to create an activeX script to run the e-mail. Couldn't find it!! Sorry!!

    Anyone have any suggestions on how to accomplish this? Any help is greatly appreacited. At this time is not a crucial problem because I reset the step everyday and it run at night without any problem, but you can figure the pain in the neck this is and god forbide if I missed one day or I am away!! The DTS will complete to the final step which is the e-mail, but then, the users won't receive the file!!

    Help anyone!!! THANK YOU!!!!!!!!!!!!!!!

  • November 10, 2005 at 1:14 pm

    #603320

    Why not use SMTP mail via: http://www.sqldev.net/xp/xpsmtp.htm

     

    You can build the filename using a the filename+getdate()

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply