Home Forums SQL Server 2005 SQL Server 2005 Integration Services how to import Excel's several sheets to DB? RE: how to import Excel's several sheets to DB?
mz1derful
Ten Centuries
Points: 1234
More actions
August 29, 2008 at 7:19 am
#864995
Take a look at the foreach container. using a variable which you set to each sheet's name or index, you can loop through the sheets and perform the transformation. hope this helps.
Karen