Thank you Uri. As you told I used the import / Export wizard and compare the package created to mine. It seems that the problem was on conversion of data. But, I have another problem. I am exporting my data to an Excel file. Before doing the actual export, I need to have two SQL Tasks, one to drop the excel Worksheet (Drop Table `MySheet`) and another to create the worksheet (create table `MySheet` Supplier longtext, SupplierName longtext). I discovered that the drop table statement does remove the worksheet but just remove the data contained in the worksheet. How to remove the sheet totaly so that I may create a clear worksheet which will receive the exported data ?Patrick

Thank you Uri. As you told I used the import / Export wizard and compare the package created to mine. It seems that the problem was on conversion of data. But, I have another problem. I Patrick, For the benefit of forum readership can you open a new thread for the new question? Thanks.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Thank you Uri. As you told I used the import / Export wizard and compare the package created to mine. It seems that the problem was on conversion of data. But, I have another problem. I am exporting my data to an Excel file. Before doing the actual export, I need to have two SQL Tasks, one to drop the excel Worksheet (Drop Table `MySheet`) and another to create the worksheet (create table `MySheet` Supplier longtext, SupplierName longtext). I discovered that the drop table statement does remove the worksheet but just remove the data contained in the worksheet. How to remove the sheet totaly so that I may create a clear worksheet which will receive the exported data ? Patrick Hi Patrick, Why not create a brand new Excel workbook every time? I don't think you will be able to drop worksheet using the standard Excel components.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

You are right. I found that the drop table worksheet name does not remove the worksheet but clears it. At least I understood how it works and adapted my work accordinlgy. thank youPatrick