Exporting to file with current date

• KumarSN

  SSC Enthusiast

  Points: 196

  More actions

  April 1, 2008 at 9:44 am

  #121362

  Hello All,

  Can someone guide me how to achive this?

  Requirement is : To backup a table to a file named as filename_currentdate.txt .This is to be done using ssis package which is called from a job.

  Thanks in advance!!

  Regards

  Sanat

• Ed Zann

  SSCrazy Eights

  Points: 8694

  More actions

  April 1, 2008 at 1:05 pm

  #796811

  You would use a DataFlow transform to extract the table data. The Destination Connection string would be composed dynamically using an expression. The expression would use a variable. The value of the variable would be set using a Script Task.

• VALEK

  SSCarpal Tunnel

  Points: 4206

  More actions

  April 1, 2008 at 9:55 pm

  #796988

  Sanata Kumar Nayak (4/1/2008)

  ---

  Hello All,

  Can someone guide me how to achive this?

  Requirement is : To backup a table to a file named as filename_currentdate.txt .This is to be done using ssis package which is called from a job.

  Thanks in advance!!

  Regards

  Sanat

  Look here and download the dtsx from here[/url]

  Look up here as well just in case.

  There is a piece of VB.NET code in the script before you dataflow task, which fixes the query and the destination connection string, which looks like this:

  Public Sub Main()

  Dts.Variables("sTableQuery").Value = "select * from [" & CType(Dts.Variables("sTableName").Value, String) & "]"

  CType(Dts.Connections("CSVFile"), ConnectionManager).ConnectionString = CType(Dts.Variables("sCSVDir").Value, String) & CType(Dts.Variables("sTableName").Value, String) & ".txt"

  Dts.TaskResult = Dts.Results.Success

  End Sub

  where sTableQuery is used by the source and CSVFile is the destination connection.

  Add the date to there and you are done!!!

  Cheers,

  M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM