September 16, 2010 at 6:19 pm
I have an OLE DB connection task that reads a store procedure that builds an xml output in one column and then it passes the xml output through a user variable that's written in a flat file using the flat file destination task. The issue is that it's doing a line feed in the middle of a tag. I am using the ragged right setting. Any suggestions on how to avoid the line feeding splits of the xml tags in the file?
Any help is greatly appreciated!
September 17, 2010 at 8:02 am
danielah (9/16/2010)
I have an OLE DB connection task that reads a store procedure that builds an xml output in one column and then it passes the xml output through a user variable that's written in a flat file using the flat file destination task. The issue is that it's doing a line feed in the middle of a tag. I am using the ragged right setting. Any suggestions on how to avoid the line feeding splits of the xml tags in the file?Any help is greatly appreciated!
I'm wondering if it's inserting the line feed the middle of the tag because you've gone past the width of the output column.
What columns do you have specified in your output connection for columns, datatypes, and column widths?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
September 17, 2010 at 11:43 am
I am using text stream for data type, which doesn't allow you to set column widths. The xml input data is set in a stored procedure using xml explicit and converted into a text.
September 17, 2010 at 1:05 pm
After loooking into it more, it's not the ssis package that's inserting the line feeds in the middle of a tag. It's the way sql server 2000 outputs the xml data. When i query a large set of data using for xml explicit, it puts the result in a block where tags and data is being cut off in the middle and then continues on the next row.
September 24, 2010 at 5:05 pm
We solved this by exporting the data to the file and following up with a Script Task that uses VB and Regular Expressions to remove the line breaks from the file.
-------------------------
"Computer games don't affect kids; I mean if Pac-Man affected us as kids,
we'd all be running around in darkened rooms, munching magic pills and
listening to repetitive electronic music."
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply