Flat File Destination Filename with Date ?

Flat File Destination Filename with Date ?

• WebTest

  either I'm missing something or this link doesn't work:

  ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/extran9/html/a4bfc925-3ef6-431e-b1dd-7e0023d3a92d.htm

  
  
  

• CBrittWardSr

  "C:\\file" + (DT_WSTR, 2)month(getdate()) + (DT_WSTR, 2)day(getdate()) + (DT_WSTR,4)year(getdate()) + ".txt"

  For example, if i use the above expression for Connection string of the Flat file connection, it will create a file

  C:\file12192005.txt

  if i run it today.

  
  
  

• HalaszJ

  Are you talking about File Connection Manager when you click browse to specify the File Path   If I put that in there of course it doesn't like it.  Where exactly are you placing in this script, what component, what tab, what property
  
  

• AndyHock

  Open BOL and paste this Url in the url box. It is not a http link.
  
  

• Chris Gillotti

  Oh, I see, I was double-clicking the file connection manager using the properties there, I didn't think to look at the VS properties pane in VS, thanks!
  
  

• noirs

  For the Flat File Connection, which is being used by the Flat File Destination, you can set the ConnectionString using Expressions, to set your file name with dates.
  
  

• Jayant Mohanty

  Do you have any resources on syntax for this
  
  

• mr pk

  For the Flat File Connection Manager, on Properties tab, you see Expressions, when you click there, you can set expressions for some of the properties for the Flat File Connection Manager. In this case, I am asking you to set the ConnectionString property as an expression.

  you should see

  ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/extran9/html/a4bfc925-3ef6-431e-b1dd-7e0023d3a92d.htm

  in BOL for further details.

  
  
  
• Flat File Destination Filename with Date ?