Viewing 2 posts - 1 through 2 (of 2 total)
By adding the IMEX=1 in the connection string of the excel connection manager as described on this KB, it fixed the issue.
Example:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\example.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1";
http://support.microsoft.com/kb/194124/EN-US/
September 24, 2008 at 9:53 am
#876484
DBReindex is growing the transaction log because it is basically dropping and recreating the indexes you are building. You can use the SORT in TEMPDB option to do all the...
March 12, 2008 at 11:22 am
#788707