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...

Ops actually it's SQL Server 2000. I am using SQL 2005 Management Studio Express as my query analyzer. I don't think sql server 2000 supports xml path. Xml explicit would...

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...

I'll check it out. The sql instance i am using is SQL Server 2005 9.00

Thanks!

Thank you for your reply!

I am not very familiar with for xml path and couldn't get it to work. Even tried a simple select statement and it keeps telling me...