I'm trying to build an SSIS package that will import a text file into Excel.
The package is always failing because of text conversion issues.
I'm attaching the the source file (text file), the Excel destination file and the dtsx package file, in the hope that someone could help solve this mystery.
All I need is to have a package that will read the text file and save it into an Excel file.
Thanks for your help,
PS: I'm having an error trying to attach the dtsx package file