Member Avatar for wewehalim

I am using BIDS 2008 to export to flat file(CSV)
it will be automatically exported at 11.00 am in the morning.
What i want to know, can we make it so the file that are being exported has a unique name each time it was being generated?
so each day, the file will be generated with different date in the file name..

for example:
filename 28/01/11
filename 29/01/11
filename 30/01/11


THANKS

  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by buddylee17
Member Avatar for buddylee17

Right click the connection manager and select properties. Scroll through the properties until you see Expressions. Add an expression for the Connection String property.

"C:\\filename " + 
(DT_WSTR,4)YEAR(@[System::StartTime])
    + RIGHT("0" + (DT_WSTR,2)MONTH(@[System::StartTime]), 2)
    + RIGHT("0" + (DT_WSTR,2)DAY(@[System::StartTime]), 2) + ".csv"

will return C:\filename 20110128.csv. The date in the filename will be the date the package is executed.

Edited by buddylee17 because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.