Solved

Cannot Import Flat File into Excel Using SSIS Package

Posted on 2012-03-23
10
455 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
  • 6
  • 4
10 Comments
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
Comment Utility
0
 

Author Comment

by:Mehawitchi
Comment Utility
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
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
btw: what is your sql server version; edition service pack?
and why you just no open - txt from excel?
0
 
LVL 42

Expert Comment

by:EugeneZ
Comment Utility
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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:Mehawitchi
Comment Utility
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 42

Expert Comment

by:EugeneZ
Comment Utility
did you install sp1 for sql2008r2?
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
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 42

Expert Comment

by:EugeneZ
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now