<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
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 1 of 3
1
2
3
»
»»
SSIS and Excel 2007
Rate Topic
Display Mode
Topic Options
Author
Message
Dinesh Asanka
Dinesh Asanka
Posted Thursday, October 23, 2008 11:29 PM
SSC Eights!
Group: General Forum Members
Last Login: Friday, February 22, 2013 9:30 PM
Points: 912,
Visits: 198
Comments posted to this topic are about the item
SSIS and Excel 2007
My Blog:
http://dineshasanka.spaces.live.com/
Post #590977
Jonathan Butler
Jonathan Butler
Posted Friday, October 24, 2008 3:15 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, March 14, 2013 8:33 AM
Points: 50,
Visits: 126
We have IA-64 servers........other than using a CSV converted version......will Microsoft ever release excel (Jet) drivers so we can use the excel Tasks?
Do you have any methods for bringing in Excel files as is on an IA64 platform?
Post #591043
Anipaul
Anipaul
Posted Friday, October 24, 2008 3:41 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: 2 days ago @ 2:50 AM
Points: 4,785,
Visits: 1,334
Nice one...
Post #591060
Madhivanan-208264
Madhivanan-208264
Posted Friday, October 24, 2008 5:44 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, September 12, 2012 5:17 AM
Points: 329,
Visits: 461
If you want to do this in sql, refer
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
Madhivanan
Failing to plan is Planning to fail
Post #591106
Jonathan Butler
Jonathan Butler
Posted Friday, October 24, 2008 6:52 AM
Valued Member
Group: General Forum Members
Last Login: Thursday, March 14, 2013 8:33 AM
Points: 50,
Visits: 126
Madhivanan (10/24/2008)
If you want to do this in sql, refer
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926
Unfortunately "Microsoft.Jet.OLEDB.4.0" does not exist for IA-64..........unless you have heard otherwise.....
If you have we would be very pleased indeed!! if so please provide MS link to the IA-64 OLEDB jet driver.
Post #591157
DavidSimpson
DavidSimpson
Posted Friday, October 24, 2008 8:18 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 10:29 AM
Points: 889,
Visits: 931
From what I've seen, importing data from excel can be very hazardous so I avoid it whenever possible. The import process will interpret your data type by sampling the data irregardless of how you define the data type in SSIS or on your destination table. So if the first part of your file contains numbers and the last contains characters... the import process will simply throw out the data with characters and load NULL's without any warnings or errors. I know there is a reg key you can set to determine the number of records that are sampled, but the fact that the Excel driver does this is bad enough for me.
David
Post #591245
Gosta Munktell
Gosta Munktell
Posted Friday, October 24, 2008 8:31 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 4:05 AM
Points: 193,
Visits: 1,248
"From what I've seen, importing data from excel can be very hazardous etc"
I agree on that.
But I have no experience with Excel2007 yet. Does it work as 2003 in this sence ?
Dinesh what do you say?
For me I will still save the sheets as TAB sep textfiles and import them so.
//Gosta
Post #591260
Gosta Munktell
Gosta Munktell
Posted Friday, October 24, 2008 8:40 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, April 26, 2013 4:05 AM
Points: 193,
Visits: 1,248
"Unfortunately "Microsoft.Jet.OLEDB.4.0" does not exist for IA-64..........unless you have heard otherwise"
If you keep to textfiles you don't need the Jet driver if you use bulk insert instead.//
//Gosta
Post #591266
btainer
btainer
Posted Friday, October 24, 2008 10:26 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, October 30, 2008 6:13 PM
Points: 2,
Visits: 8
Awesome. Thank you. I could have used this last week... but I got through it.
I had to do a comparison of an excel 2007 file to an sql table and follow that with a report on the findings in SSRS.
I found that I had to export to an earlier version of excel for the reporting services piece. I couldn't find how to use a driver for excel 97 in reporting services. Did I miss something there?
Thank you
Post #591356
mcloney
mcloney
Posted Friday, October 24, 2008 10:28 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, January 23, 2013 11:08 AM
Points: 223,
Visits: 82
David (10/24/2008)
From what I've seen, importing data from excel can be very hazardous so I avoid it whenever possible. The import process will interpret your data type by sampling the data irregardless of how you define the data type in SSIS or on your destination table. So if the first part of your file contains numbers and the last contains characters...
I have found this to be true as well. I haven't started experimenting with SSIS in 2008 yet, but hopefully there's a setting that addresses this. From what I remember, SSIS only looks at the first 200 rows to try to analyze the data type. It would obviously be better if it tried to find every possible data type in a column and then chose the lowest common denominator.
However, I'd make the argument that one should be familiar with the data that's being imported, and should therefore be able to anticipate any data types for each column, and handle any deviation with row redirects to text files so that the package execution doesn't come to a dead stop because of a few bad apples in a source.
Cheers,
-m
Post #591360
« Prev Topic
|
Next Topic »
27 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
