SQL To Excel Data Dumping with the help of SSIS flow task.
I am trying to do a Sql To Excel Data Dumping with the help of ssis flow task.I create a sql connection and give the query in the sql source.I aslo have a excel template to map in excel destination ready which has around 400 columns/fields.In bettween i use a dataconvrsion for unicode/non unicode issue.Now [...]

Answer Question   |  July 19, 2010  3:37 PM
Excel 2003, Excel Metadata, SQL Server database, SQL to Excel Database Conversion, SSIS Package

ExcelSource file – metadata validation
I need some assistance. I am using an excel file to import data to SQL tables. The problem I am running into is having to replace the metadata of the output columns with the metadata of the external columns. I do not want to do this manually everytime. [The metadata of the following output columns [...]

Answer Question   |  December 5, 2008  4:44 PM
Excel Metadata, Microsoft Excel, SQL tables, SSIS