Thanks Fran and everyone for your responds. It works! I had the 1st sql task barrel with Drop Table then once that succeeded, move to create table on the second...

I got this error:

Error Source: Microsoft Jet Database Engine

Error Description:

Syntax Error in Create Table Statement.

Perharps, that Excel does not like these statement?

Thanks everyone for your responds.

Thanks Allen for your respond!

However, I still get the error with the codes above you gave.

I've encounter the same problem. So, i installed Excel on our test server and it works just fine. However, I still do not know the impact of installing Excel on...