Entering filename into database column

• superc0ntra

  Old Hand

  Points: 375

  More actions

  March 31, 2005 at 8:12 am

  #61002

  I am doing an import from excel into a SQL server table through a datapump task. How can I get the filename of the excel, which is the same as the uploading company, strip the .xls extension and insert it in a column (company, nvarchar(50), not_null) in the target table.

  
  ------------------------------------------
  
  Did you know that if you don't drink your milk every morning, the Arla-rabbit will come and shoot you in the head, or sometimes in the belly?

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  March 31, 2005 at 11:44 am

  #549897

  Personally I pull the filename into a global variable and assign the variable as a part of the data pump using activex

   

  Function Main()

   DTSDestination("FileName") = DTSGlobalVariables("gv_TableName").Value

   Main = DTSTransformStat_OK

  End Function

  ---

  
  Shamless self promotion - read my blog http://sirsql.net