Post reply

File Sampling

  • March 3, 2009 at 2:51 pm

    #155362

    Hi everyone,

    I have a flat file source and it has n rows. generally n is around 1000-1500 rows. Now I need jsut 200 rows across the file. I have added a script component which creates an identity Col. I have count of the rows and "n/200" gives me which row to go and get the data.

    I cant figutre out a condition to achive this. Any help would be great! Thanks!

  • March 4, 2009 at 9:54 pm

    #953756

    In your data flow task, add a percentage sampling transformation. It will split the data into 2 paths. Pass the path you want to your next transformation.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply