Hi All, I need to load data from sql query to xls file ..... how do i create a xl file dynamically with rundate (need to append getdate()) ....how do i map the columns ... Thanks apps

Hi apps, Please note that there is no SSIS 2004, you probably meant 2005 version. To answer your question I will give you examples. First one: this is how to set the file name of the output Excel file dynamically: http://geekepisodes.com/sqlbi/2011/creating-excel-files-xls-dynamically-from-ssis/, and Second: How to Output Data to Excel File: http://cavemansblog.wordpress.com/2009/04/17/ssis-export-data-from-sql-server-2005-to-excel/Arthur My Blog

But make sure you note that there is no Jet Oledb Driver available to run on 64 bit machine. There is still an alternative to run such a package. Hope it helps. Thanks, Pulkit Ojha Microsoft Business Intelligence Developer

H iarthur , I followed the first link ...... i created a excel sheet in the generated file ...... and i wrote the expression in excel connection manager as they mentioned in the link .... but unable to load the data into generated excel file or excel sheet ... and i did data conversions before loading ... Thanks, apps

Hi , How can i use Template excel file ......... and i need to rename it everytime when the package runs .... Thanks Apps

Hi , How can i use Template excel file ......... and i need to rename it everytime when the package runs .... Thanks Apps

You can just create the template Excel file manually. Set the package's Excel connection to use this name. Then when processing, just before you begin you can save this untouched Excel template to a different directory. One the processing is finished successfully you rename the file that you populated and then copy the template into the working directory. I also trust this post is of help to you: Using #Excel Templates in #SSIS - #SQLServer http://brandietarvin.livejournal.com/28230.html Arthur My Blog

In my local system it works fine ..... when the user executed it in some other system .....How it can ...?

Need to know what went wrong. Enable a thorough logging and post here the error message(s). My impression the "user" rights is the issue.Arthur My Blog

[Excel Destination [11604]] Error: An OLE DB error has occurred. Error code: 0x80040E37. [Excel Destination [11604]] Error: Opening a rowset for "'Weekly Payment Upload$'" failed. Check that the object exists in the database. [DTS.Pipeline] Error: component "Excel Destination" (11604) failed the pre-execute phase and returned error code 0xC02020E8.

Hey Finally i got it ..... byy using EST i am creating Sheet and ... and in excel connection manager .... in expressions i am writing the File_Path Variable + File_Name ..... and in excel destination i am creating one more new sheet with the same name from EST ..... now everything is ok .... and more issue is i dont want column names in excel sheet ...how is it possible .... Thanks Apps