October 18, 2009 at 2:01 am
Hi there
I have been given a task to take a SQL Server DB and create some output in Excel. Data in the DB are coming through in a single field, which then needs to be split further into other fields depending on the response. e.g.
100000 washing machine
100000 hair dryer
100001 washing machine
100001 hair dryer
to:
100000 washing machine hairdryer
100001 washing machine hairdryer
Is there an SSIS function to help do this?
Many thanks.
October 18, 2009 at 2:27 am
Dupe post, please see http://www.sqlservercentral.com/Forums/Topic804758-1291-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy