I just wanted to know why is that error recevied?

how can i rectify it?

I mean if i choose special format under that home phone number means the data will be like this (XXX) YYY-TTTT...or if i am going to choose social security number...

opc.three (1/7/2013)

---

manibad (1/7/2013)

---

I will list out the things what i have done.

1.In data flow task,OLE DB source->Sort->Data conversion->Excel destination(target is Format.xlsx(template file))

2.In file system task,Source path is Format.xlsx(template) and destination...

I will list out the things what i have done.

1.In data flow task,OLE DB source->Sort->Data conversion->Excel destination(target is Format.xlsx(template file))

2.In file system task,Source path is Format.xlsx(template) and destination file name...

opc.three (1/3/2013)

---

The only way to format an Excel Workbook programmatically using SSIS is to leverage the Excel Object Model from a Script Task.

One technique I have used in the past...

Special formats for example...in excel sheet if you choose "Special format" under that "Social security number" the data specified in such a column would be always in SSN format..

I...