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 |
|
Ravi0435
Starting Member
47 Posts |
 Posted - 2007-06-05 : 14:39:54
|
| Hi, I am working on building SSIS Packages which will need to extract records from OLTP Servers, and i am half way through building the package, i wanted to test if it is able to extract the records from a particular table on OLTP....basicall i want to test if the package built so far running good?....but the extraction part takes ages as there are millions of records in the OLTP ...i want to limit those records to say some thousands so that i can test it and work on cleaning part in the staging and later after all the chunks are working perfectly i want to set it completely to run for extracting all the millions of records.Any suggestion would be appreciated.thanksraviNothing much that i can do..!! |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-06-05 : 14:43:09
|
| [code]SET ROWCOUNT xx [/code]Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Ravi0435
Starting Member
47 Posts |
Posted - 2007-06-05 : 14:53:29
|
| yeah i was thinking of that but WHERE..??As an "OLE DB COMMAND" Transformation in my DATA FLOW TASK ..??ravi..Nothing much that i can do..!! |
|
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-06-06 : 04:06:08
|
| In the OLEDB source apapter in your dataflow task. What data access mode are you using here?Mark |
|
|
|
|
|
|
How to limit the records..?