Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SeekingWisdom
Starting Member
24 Posts |
 Posted - 2009-03-03 : 20:32:40
|
 Hello! I am new to SSIS and I have the following need. I am presently testing an SSIS package and I am unable to conduct a valid test because or database does not contain the data that I need. I can notuse an OLE DB Source (connected to the production server) in a dataflow connected to a OLE DB Destination (connected to the TEST server) because I can not select a set number of rows. The table in question contains several millions rows and I only need a couple of hundred rows moved to the TEST database. Can anyone share how I could go about accomplishing this feat? How can I perform a conditional select based on specific values and pass the selected rows to the TEST database? I hope I am clear on my need. Thanks. |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2009-03-03 : 20:56:49
|
| In your OleDB Source, use an SQL query rather than selecting the table name from the list. You can write your SQL query with the appropriate WHERE clause(s) to restrict the data as necessary for testing.hth,Tim---------------------Tim Mitchellwww.BucketOfBits.com |
 |
|
|
|
|
|
Moving Data from server to another