Solved

SSIS Parsing question

Posted on 2009-04-07
6
397 Views
Last Modified: 2013-11-10
I have a flat file that has EOR at the end of each row...When I use EOR as the row delimiter The data goes into my source table but it doesnt appear correct(I think because it also has a CR LF on each row). Is there anyway I can either write a SQL statment that goes by the EOR to distinguish the end of the row and then insert that row? Or, can I convert this flatfile into an excel spreasheet because it looks exactly how I need it in a spreadsheet for some reason and then I can load it into my SQL table? Any thoughts?
0
Comment
Question by:healthcheckinc
  • 3
  • 3
6 Comments
 

Author Comment

by:healthcheckinc
ID: 24088522
Additionally when I use CRLF as my row delimiter I get an error saying that the last column delimiter was not found????
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24088526
Could you attach the flatfile example here?
Regards,
Pedro
www.pedrocgd.blogspot.com
0
 

Author Comment

by:healthcheckinc
ID: 24089011
Here ya go Pedro...I have the text qualifier set to " but the last column isnt being qualified for some reason???
ProctorTest1.txt
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 22

Accepted Solution

by:
PedroCGD earned 500 total points
ID: 24095567
Add the attached package to an existent SSIS Solution.

My Steps:
1. Split each row by delimiter ;EOR
2. Replace all " by empty
3. read each column in the source....

I only created 3 column in the output of the script component, you should create all the other columns.
Update the path inside ForEach Loop.

Helped?
Regards,
Pedro

www.pedrocgd.blogspot.com
SSIS-Interface0.JPG
SSIS-Interface1.JPG
SSIS-Interface2.JPG
SSIS-Interface3.JPG
SSIS-ScriptCode.JPG
Package-EE99-dtsx.txt
0
 

Author Closing Comment

by:healthcheckinc
ID: 31567572
Thanks for your help Pedro, once again!!
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24097209
you welcome! :-)
Visit my blog and leave a comment!
Pedro
www.pedrocgd.blogspot.com
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

863 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

22 Experts available now in Live!

Get 1:1 Help Now