March 3, 2009 at 6:31 pm
[:)]
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.
March 4, 2009 at 7:41 am
Your source can be a query so you can put in the query with your conditions in the Dataflow source or you can create a stored procedure that contains your conditions and use that as your source query.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 6, 2009 at 5:39 pm
🙂
Thank you very much for the feed-back and the suggestions.
God Bless.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply