Thanks so much, that's awesome

Thanks

Hi I have same problem, I could not follow you could you please explan little more detail what to do.

It would be really great help, I spend, 5 hrs on...

thanks

Thanks for your help

Thanks, it's even shorter.

Yes, I got answer but its long and it's in look.

praveen , thank you so much it same whole lot of code

This is what I did finally and it works,

declare @a int

select @a = MAX(empid)+100 from dbo.employee

declare @no_row int

declare @count int

set @count = 1

select @no_row...

The way you suggest will make file name static. For Static I do not have to go all this long way. In SSIS, before loading data in Excel it look...

I did that, it throw next error some thing like

"Error at Data flow task [Excel Destination [30]]: SSIS eRROR cODE dts_E_oledberror. An OLE DB error has occured. Error code: 0x80040E37.

Error...

First I create a package level, String Data type variable.

I have data flow task, Data is retrieving from OLEDB Source to Excel Destination. For simplicity I made source table all...

Lynn, Yes you are correct I did open .csv file in Excel the problem is some of the data have , in middle so it is creating new column in...

Thanks anthony.green, this is perfect. You are awesome.

Thanks luis, it's almost close what I want