Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSIS importing unstructured file in to SSIS

Posted on 2012-03-30
2
Medium Priority
?
1,089 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 1500 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

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.

Question has a verified solution.

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

In this article I will describe the Backup & Restore 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.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
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…
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…

972 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