SSIS Question
-
Hope this is the right place - is anyone using SSIS here? Let's say I have an input source which gives me a column of data that I'm interested in. Before inserting this data into my target, I need a couple of additional columns added to this data. One column is a sequence, 1, 2, 3, etc.. and the second column is a literal string. I'm pretty new to SSIS and I'm having some trouble getting off the ground. Can anyone point me in the right direction? Thanks! Marcus
Marcus Spitzmiller You will never hear me say, "I listen to pretty much everything." That is for people who don't care what goes in their ears.
-
Hope this is the right place - is anyone using SSIS here? Let's say I have an input source which gives me a column of data that I'm interested in. Before inserting this data into my target, I need a couple of additional columns added to this data. One column is a sequence, 1, 2, 3, etc.. and the second column is a literal string. I'm pretty new to SSIS and I'm having some trouble getting off the ground. Can anyone point me in the right direction? Thanks! Marcus
Marcus Spitzmiller You will never hear me say, "I listen to pretty much everything." That is for people who don't care what goes in their ears.
Use a Derived Column task to add new columns to the data. If I work out a simple method to generate a sequence, I'll let you know.
-
Use a Derived Column task to add new columns to the data. If I work out a simple method to generate a sequence, I'll let you know.
Thanks for the help!
Marcus Spitzmiller You will never hear me say, "I listen to pretty much everything." That is for people who don't care what goes in their ears.