Solved

SSIS importing unstructured file in to SSIS

Posted on 2012-03-30
2
1,047 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 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

821 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