Importing scatered Data from the Excel File / Sheet

Question

Importing scatered Data from the Excel File / Sheet

Sandesh Kadam-335754

Mr or Mrs. 500

Points: 523
More actions
July 19, 2007 at 5:09 am

#125116

Hello Gurus,
I wonder if anybody has come accross / achived importing very much scatered data form excel file using SSIS. Scatered 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 weard but thats what is the requirement and i am facing the wall to make it happen. All tried of providing them the template and stuff... Also tried using the mediating excel file to have linked data. but then their are going to variable many more files to come in future and obvious their names are going to be different.
PLEASE HELP ME...

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Crispin Proctor SSCoach Points: 18161 More actions · Answer 1

Welcome to my world

There is actually a brilliant tool called Data Defractor which allows you to drill into the data. You specify boundries etc and pattern matching and it gives you the data in a tabular format.

I have been using it on many complex documents and it is a life saver.

See http://www.datadefractor.com

HTH

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Sandesh Kadam-335754 Mr or Mrs. 500 Points: 523 More actions · Answer 2

Hi, thanks for the help, i did try that but no luck with it. May be i did not understand it properly. May be i need to look more in detail for its use.,

Crispin Proctor SSCoach Points: 18161 More actions · Answer 3

I think you should look at it again. It is really powerful and adaptable. I have yet to find a situation where it cannot get at the data reliably.

Post a couple questions on the forum there is you need help.

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Sandesh Kadam-335754 Mr or Mrs. 500 Points: 523 More actions · Answer 4

Thanks Crispin,

I looked at it and am trying to make it happen, meanwhile its took expensive to go ahead with and hard to convince the client to make a purchase of :-(. Don't see any other way then calling the the .net dll for process.

Crispin Proctor SSCoach Points: 18161 More actions · Answer 5

You could use Office Automation although that is frowned upon for a service app. Not really a good idea.

It is always an issue with semi structured data and getting it into a structured format. Sadly, people need to pay for the use.

To be honest, is the cost of the license really more than your man hours, vast amounts of debugging and, no offense intended, an possible unstable import. Small changes could break it.

So many people are penny wise, pound foolish.

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Sandesh Kadam-335754 Mr or Mrs. 500 Points: 523 More actions · Answer 6

I totally agree to you in your saying for pound foolish, as i am getting to the end of the presentation and try my luck if i could get this bought its so easy, but i have to tackle one of my colleage as well who says we built the .net object to read the dynamism 🙂 can you imagine, he smells to leave a bug and come in future to fix it. 😮 I said it.