Tell to split on change of ID

Tell to split on change of ID

• Digital_Trucker

  here's what I'm trying to do...this is the best way I can think to do all this via your articles I read...I'm still new to all this remember so this may not be correct but here's what I'm working on as the solution at the moment but failing miserably so far:

  http://www.webfound.net/myplan.jpg

  
  
  

• Keystone

  The first 2 posts here may help: http://blogs.conchango.com/jamiethomson/search.aspx q=multiple+output&p=1

  There's plenty of other stuff on my blog in regard to script components with quite a few downloadable examples as well.

  -Jamie

  
  
  

• Anandgb

  Here is a package that seems to do what you need. http://www.sqlis.com/default.aspx 54

  I have not tried it or even viewed it, so I will not be able to "walk you through it" or provide any help for it. but it appears to accomplish what you are describing...

  
  
  

• Vikas Verma [MSFT]

  I'm also having trouble setting up the Recordset variable

  http://www.webfound.net/recordset_variable.jpg

  I don't understand where to create this and what this all means....sorry, I need low level information...I'm just trying to learn here. I am reading whatever articles I can!

  
  
  

• LauraH

  I'm looking at this

  http://blogs.conchango.com/jamiethomson/search.aspx q=for+each+loop+with+ado&p=1

  ok, fine but there are some problems I'm having...such as how to populate the recordset from my ole Db object. I linked my ole db component to a recordset but don't understand the inter workings. I figured once I get this into a recordset, then I can l oop through it and do like an IF mnt_HeaderID is the same type of thing, then write it to a file

  Again, this is all I have so far as my attempt:

  http://www.webfound.net/recordset_attempt.jpg

  http://www.webfound.net/Loop.jpg

  
  
  

• monkey627

  You can't. The conditional split works row-by-row. You would need to use a script component to do that.

  -Jamie

  
  
  

• TonyK.

  Jamie, can you walk me through it
  
  

• youngblood

  Very good stuff, however I have till 4pm to figure out my split or my boss is having me scrap SSIS altogether....I am screwed. I have a learning curve to get over first!
  
  

• BlackSwan

  I'm taking a stab but not sure how to code the vb:

  www.webfound.net/transform1.jpg

  www.webfound.net/transform2.jpg

  www.webfound.net/transform3.jpg

  
  
  
• Tell to split on change of ID