May 22, 2008 at 1:29 pm
I have been told that using scripts should be a last resort as it will slow data processing down in SSIS... and I have a column which I need to split into multiple columns, based on the position of the data - can I do this with Derived Column or some other tool? Is the script component necissary?
thanks in advance!
May 22, 2008 at 3:27 pm
What is the condition on which you want to split the column? You may use a derived column yes...
Go here: http://msdn.microsoft.com/en-us/library/ms141232.aspx for some details on the expression language you can use to accomplish this...
Ben Sullins
bensullins.com
Beer is my primary key...
May 22, 2008 at 4:13 pm
Thanks for the link - will definately come in handy as I learn the ropes!
Turned out that I was not importing the flat file correctly - I set the header delimeter to {CR}{LF} but had not specified the row delimeter... so when I was trying to bring the file in it would end up truncated unless I ignored the header, which has information I need.
I was trying to extract parts of the string based on location and length of data and the leading character of the string... now that I am accessing the file correctly I am just setting up my columns as I import the file and all is well.
Thanks again for the quick reply!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply