SSIS and Excel 2007

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Dinesh Asanka » SSIS and Excel 2007

27 posts, Page 3 of 3

«««1 2 3

SSIS and Excel 2007

Rate Topic

Display Mode

Topic Options

Author

Message

James Raddock

Posted Wednesday, October 29, 2008 4:03 PM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 04, 2010 11:33 AM
Points: 43, Visits: 102

Convert to CSV and import. Importing from excel has too many inherent problems. Back in 2002 I wrote a custom parser that had to handle this exact problem because even after hacking the jet drivers registry settings Excel still had problems. Just write it to a text file....It's very easy to write a simple .NET app to convert csvs to text automatedly.

Post #593987

Ravi Kumar V

Posted Wednesday, November 05, 2008 11:07 PM

Forum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:05 AM
Points: 9, Visits: 226

GOOD ONE !!! :)

Post #597911

Alan_C

Posted Tuesday, July 14, 2009 2:03 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, September 11, 2009 5:40 AM
Points: 45, Visits: 14

guruprasat85 (10/26/2008)

thanks Dinesh but in Sql Server 2005 its easy too.. All you have to do is to use a data flow task and you are on!! :D

Can you elaborate please? I thought what Dinesh described was a data transformation task. You mean there is an simpler more intuitive way? It's not obvious to me.

Post #752510

darshan28

Posted Monday, August 24, 2009 9:45 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 10:51 AM
Points: 372, Visits: 280

me too getting same error any solution plz

Post #776424

richardbartonbrown

Posted Thursday, June 24, 2010 2:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 7:26 PM
Points: 4, Visits: 146

This is a year later, but maybe somebody finds their way here and encounters the "Test connection failed because of an error in initializing provider. Invalid UDL file." or similar UDL error. I got this and investigated other how-to-define-SSIS-Excel articles. This one
http://blog.tylerholmes.com/2007/12/walkthrough-connecting-to-excel-2007.html
mentioned that you must install "Microsoft Office 12.0 Access Database Engine OLE DB Provider" and gave this MS link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

When I install the MS component and follow the steps in the first link -- they are slightly different from this SQLServerCentral article -- the UDL errors go away.

If an additional download is indeed the fix, then that sucks -- MS gives us the option of picking a Connection Manager OLE DB Provider that is not loaded on the system...ugh.

Post #942691