USE SSIS to move only top 5% of a given database inot test site.

Question

USE SSIS to move only top 5% of a given database inot test site.

Faye Fouladi

SSCrazy

Points: 2770
More actions
September 22, 2008 at 1:33 pm

#193375

Is it possible to write scripts for SSIS to slice a database to be placed in the test site? I don't want to move the entire database to the test site, just a portion of it. How do I do that?
Faye

Viewing 5 posts - 1 through 4 (of 4 total)

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

VG-619426 Hall of Fame Points: 3914 More actions · Answer 1

I don't know this is possible in SSIS.

What we did similar is scrubbing the data based on some date range, we use this for demo and local installation rather than production backups.

VG

Alan. T. Hall of Fame Points: 3221 More actions · Answer 2

If depends on how you want to slice it. In you OLEDB data source you can specify a TSQL statement and if you can put that slice into TSQL this will work.

In the SSIS data flow you can designate a percentage that is put into the output stream.

In the data flow tab

1. Create a data source OLEDB

2. Choose the percent sample tool and select the percent and which stream to put it into

3. Chose you data destination

I have only used it once but it seemed to work.