Cannot Import Flat File into Excel Using SSIS Package

Hello Experts,

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
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
did you try to create the basic SSIS pack by usinf SSMS import-export ?

to upload DTSX - save it as txt file ...
MehawitchiAuthor Commented:
MehawitchiAuthor Commented:
Thanks EugeneZ,

Yes I did try the import/export wizard, and the package failed.

I have attached the package after renaming the extension as .txt.

Please rename back to .dtsx

Thanks again,
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
btw: what is your sql server version; edition service pack?
and why you just no open - txt from excel?
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
can you try to import txt to sql table and from sql server export to excel?
also check
MehawitchiAuthor Commented:
Thank you EugeneZ,

The article seems very informarive, I'll read it and hopefully it will help me solve my problem.

I have SQL Server 2008 R2.
I can simply read the text file from Excel, but I want to design an SSIS package because I want to automate this process.

EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
did you install sp1 for sql2008r2?
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
did you try to import txt to sql server table and from table to excel as ssis? there can be problems with data types conversion via ssis for txt directely to excel..

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
EugeneZ ZhitomirskySQL SERVER EXPERTCommented:
what about to use not ssis way? for example: Importing text files in an Excel sheet
or vba macros inm excel?
MehawitchiAuthor Commented:
Thank you again EugeneZ

I will try to solve the problem by reading the very informative article on Exporting to Excel using SSIS, which you have provided. If I don't succeed, my last resort will be to import first to SQL table and then on to Excel
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.