April 5, 2012 at 12:13 am
hi all,
i have a 100 records in a flat file source , i need to send only the
first 97 records to target in ssis
can any one help on this......
April 5, 2012 at 1:13 am
maheshkrishnas (4/5/2012)
hi all,i have a 100 records in a flat file source , i need to send only the
first 97 records to target in ssis
can any one help on this......
Use a staging table then use a second dataflow to select top 97 * from x and send it to the real target. Easiest and best method. Anything else is over-complicated.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
April 5, 2012 at 3:48 am
Evil Kraig F (4/5/2012)
...Anything else is over-complicated.
Been thinking for 5 minutes to come up with a better and simpler solution, but you're right, there isn't any. 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply