DTS Export to dynamic output filename

Last Post 10 Oct 2007 01:05 AM by ramprathap. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
craigmurphy
New Member
New Member

--
08 Jul 2004 07:53 AM
We have a DTS package that runs nightly and exports data to a .csv file. However it will overwrite the file if nobody renamse it first. Ideally I would like to have the date as part of the filename. For example the output file is DailyAPHeader.csv. Would like to name it as 07072004DailyAPHeader.csv.
How do I get the DTS package to dynamically name the export file?

Thanks, this would be a great help.

Craig
craigmurphy
New Member
New Member

--
14 Jul 2004 08:05 AM
Thanks !!

I will definitely try this.

And you are correct, it is not a large dataset being exported. It's daily Invoice and Purchase Order info.

Craig
ramprathap
New Member
New Member

--
10 Oct 2007 01:05 AM
hi
i tried your code , the problem iam facing with this is , the .csv file is created , when i open all the data comes in one column , not as seprate olumns .

Could you please guide me in get around this
You are not authorized to post a reply.

Acceptable Use Policy