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)
 Importing scattered Data from the Excel File / She

Author  Topic 

sandesh27uk
Starting Member

2 Posts

Posted - 2007-07-19 : 07:18:44
Hello Gurus,

I wonder if anybody has come across / achieved importing very much scattered data form excel file using SSIS. Scattered I mean by reaching to the particular row and particular column and then referencing it to the another row and column and then import the (no) number of rows from then....

I know its weary but that's what is the requirement and I am facing the wall to make it happen. I tried all, providing them the template and stuff... Also tried using the mediating excel file to have linked data. but then there are going to variable many more files to come in future and obvious their names are going to be different.

PLEASE HELP ME...

Sandesh Kadam
   

- Advertisement -