Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Cannot Import Flat File into Excel Using SSIS Package

Posted on 2012-03-23
10
Medium Priority
?
472 Views
Last Modified: 2012-03-25
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,
Hani

PS: I'm having an error trying to attach the dtsx package file
Ipsos-Grid-March-10-16.TXT
Ipsos-Staging.xls
0
Comment
Question by:Mehawitchi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 43

Expert Comment

by:Eugene Z
ID: 37760612
did you try to create the basic SSIS pack by usinf SSMS import-export ?

to upload DTSX - save it as txt file ...
0
 

Author Comment

by:Mehawitchi
ID: 37761102
0
 

Author Comment

by:Mehawitchi
ID: 37761107
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,
Hani
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 43

Expert Comment

by:Eugene Z
ID: 37761164
btw: what is your sql server version; edition service pack?
and why you just no open - txt from excel?
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 37761178
can you try to import txt to sql table and from sql server export to excel?
also check

 http://www.excel-sql-server.com/sql-server-export-to-excel-using-ssis.htm
0
 

Author Comment

by:Mehawitchi
ID: 37761586
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.

Thanks
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 37761719
did you install sp1 for sql2008r2?
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 1500 total points
ID: 37761724
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..
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 37761779
what about to use not ssis way? for example: Importing text files in an Excel sheet http://www.jkp-ads.com/articles/importtext.asp
or vba macros inm excel?
0
 

Author Closing Comment

by:Mehawitchi
ID: 37762731
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
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question