April 17, 2008 at 1:40 pm
:crazy: Kind of New to SSIS packages, don't really know how to start tackling this project.
In input a regular sql table native client record source, in output a flatfile but the fun is in between.
Each record from the source file contains a key and a text type field which is to be written in chunks of 40 bytes to output flatfile, generating n records per source record (a text of 120 digits will produce 3 output records), and also writing the source record key and a sequence number on every destination record, starting from 1 on every key change. Done it before with VBA and access but now i need to do it in SSIS... Any suggestions would be appreciated
April 17, 2008 at 1:53 pm
Sounds like a job for a script component. If you've done some VBA programming, you may be able to do this fairly quickly. You can read in your input rows one at a time, and do a split using 40-character substrings within a loop. You can also use an incrementing integer within that loop to assign your sequence number.
If you need some help with the script task, post back with a few lines of sample input and I'll be glad to send you some code.
hth,
Tim
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
April 17, 2008 at 2:05 pm
I'll give the script component a few shots and then I may need more help.
Thanks Tim I appreciate it. 😀
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply