This is the first time I use Excel Source in SSIS, I received this error:
An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80004005 Description: "The Microsoft Access database engine cannot open or write to the file
Normally, I use flat file, but I need to convert the data type. I was wondering if using Excel Source would be better and how I can get around with the error. thanks
Far better to use flat file / csv.
>but I need to convert the data type.
Explain this, as derived columns can be done regardless of source/destination.