http://msdn.microsoft.com/en-us/library/bb522577.aspx

I got the answer from MSDN site.

Thanks

We are loading the data to an excel file which is on a shared folder, no issues when we are loading the data about 550K but when we tried to...

Hello krisna

thank you for your reply.

I am using excel 2010, there is no issue when I am loading the data in my laptop but when we run it on the...

Thank you Mordred

but I am not using any fast load option, I am simply loading the data from SQL database to Excel.

I tried to format the columns in template itself but when I look at the data in that excel show advanced editor /input output properties, its still taking them as...

I am using template, first my package copies this template into another folder and then write the data into that.

I am using Excel 2007.

I did the same thing as you did but the excel column shows the data type as unicode string [DT_WSTR].

My excel file is not saving the...

2.1 Formatted ID column as a number with no decimal spots, data type: double precision float [DT_R8]

2.2 Formatted Money column as currency with 2 decimal spots, data type: currency [DT_CY]

Hello...

Thank you for your reply Mordred.

I did all the data conversions but the target excel file is taking all the values as text only, even if I change the data types in excel show advanced...

I faced the same issue as you are facing now. You can get the csv or txt file names dynamically because they don't need the column names in the beginning,writing...

It seems the error is because of excel file name, give the name of the excel file as test.xls as your dynamic file name is test2012-08-13.xls. Try with this.

Instead of connection string in excel connection manager properties use excel file path.

I faced the same error and got solved with this change. I hope it will work for you.

Simply replacing the file extension won't work with excel.

Can you please post here how you are adding the date column at the end of the file name ,are you...

unable to convert between Unicode and non Unicode data type

I generally find this issue when I am dealing with excel where some of the columns in the database are in...