Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to import excel sheet with varying no. of columns in ssis Expand / Collapse
Author
Message
Posted Saturday, June 7, 2014 12:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 3:16 AM
Points: 10, Visits: 173
Hi,
I have a requirement to import excel sheet which we receive daily, sometimes it may contain extra columns that needs to be imported to staging table as it is.

Please do the needful...
Post #1578566
Posted Monday, June 9, 2014 1:39 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 2,533, Visits: 7,100
ykonline (6/7/2014)
Hi,
I have a requirement to import excel sheet which we receive daily, sometimes it may contain extra columns that needs to be imported to staging table as it is.

Please do the needful...


Simplest way is to always import the maximum number of column ever needed and then ignore those which are completely empty in the staging area. That is easily handled in SQL and requires trickery in SSIS.
Post #1578713
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse