CSV file as source for SSIS package with datestamp

• sql_novice_2007

  Hall of Fame

  Points: 3307

  More actions

  July 25, 2011 at 6:52 am

  #241996

  Hi,

  I need to create one SSIS package which will have a csv file as source but the name of the will have current day's dateattached to it.

  Datafile07252011.csv for today and Datafile07262011.csv for tomorrow.

  Can anyone help with this?

  Thanks.

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  July 25, 2011 at 8:13 am

  #1357803

  The following is an example.

  Hopefully it will give you some ideas.

  http://sql-bi-dev.blogspot.com/2010/08/dynamic-ssis-package-to-import-excel.html

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  July 26, 2011 at 5:22 am

  #1358373

  In this case I do usually use ForEach loop container and simply copy the file into “Work” folder and renaming it to the fixed name. Then connection can be configured to use constant file name.

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]