Solved

SSIS importing unstructured file in to SSIS

Posted on 2012-03-30
2
1,044 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
2 Comments
 
LVL 39

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

The password reset disk is often mentioned as the best solution to deal with the lost Windows password problem. In Windows 2008, 7, Vista and XP, a password reset disk can be easily created. But besides Windows 7/Vista/XP, Windows Server 2008 and ot…
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.
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

803 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