Solved

SSIS importing unstructured file in to SSIS

Posted on 2012-03-30
2
1,056 Views
Last Modified: 2012-04-05
Please does any one know how i can import unstructured files like this to SSIS
htwewe2 22323 232323 ssddfdf 33e
23232323 wewew22 22323 wqeweew223322323
23232323 wewew22 22323 wqeweewty9098768
45454544 wewew22 34343 wqeweew223322323
0
Comment
Question by:olaayo
[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
2 Comments
 
LVL 40

Expert Comment

by:als315
ID: 37790134
You can have different number of columns in different lines? What result you like to have?
0
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 37791480
check this article.. it has a step by step process on how to handle this very situation

http://geekswithblogs.net/evankoch/archive/2007/09/19/115450.aspx
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

717 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