SSIS-Standardize excel tab name

• vijaya-430249

  Old Hand

  Points: 365

  More actions

  November 3, 2008 at 10:43 pm

  #125698

  I have craeted a SSIS package to load excel file in to a staging table.

  Created 2 variables,one for the excel file path and second one has an expression to store the tab name.In this scenario Excel file name and the sheet/tab name is same.

  Ex:Excel file path:- D:\Sample\abc.xls

  Tab name:- abc

  This is working fine for one excel file.But for multiple excel files it is not working even if I take For each file enumerator.It will read only excel files in that folder,but not the corresponding tab names.

  The problem I am having is that if another excel file come previously set tab name parameter value sholud also change.

  Is there anyway in SSIS I can retrieve the name of the excel worksheet and pass it into a variable at runtime?

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  November 4, 2008 at 9:27 am

  #893701

  Vijaya,

  You are double posting . I have already answered your question here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/