Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  SSIS Package to import XLS

Author  Topic  jwe Starting Member 13 Posts Posted - 2007-10-19 : 07:45:23 Hi there, I have DTS package in 2000 but I want to re-write it in SSIS. I am fairly new to SSIS so are just looking for pointers. The package imports data from and XLS book with around 50 worksheets each representing a separate table. I import these into 50 separate (semi permanent) tables and then do my data manipulation once the data is in the tables. I do this with my DTS package by creating 50 separate transform data tasks which works but frankly looks a mess. Can I do this with SSIS with only one transform task from the XLS book? Any pointer would be appreciated. Thanks.