I have to agree with Koen here. The correct answer here is not SSIS, it's replication, log shipping, or mirroring. SSIS is point in time upkeep on large data sets for transformations. It's not meant for continuous data transfer.
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