question

Zahid avatar image
Zahid asked

Why DTS taking time to import data from excel 2007?

Hi, Can anybody tell me that Why DTS taking time to import data from excel 2007? thanks in advance
sql-server-2008-r2exceldts
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
@Zahid, you have tagged this as 2008 R2 - is this really an R2 question?
1 Like 1 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
@Kev - Agree, Its either DTS OR SQL 2008 R2 - DTS stopped with SQL 2000 ...
0 Likes 0 ·

1 Answer

·
Oleg avatar image
Oleg answered
Probably because of the drivers. Unfortunately, 64-bit drivers don't even exist, and if you have 32-bit SQL-Server then you are OK, but probably need to get the latest version of the drivers. To quickly check whether this is a problem, try to open the Excel 2007 file, save it in older 2003 (xls) format, modify your package and see if the speed to import data increased. If it did then you can either try to find a later version of 2007 driver, or work with 2003 (xls) files for now as a workaround. Oleg
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.