psc032802 (11/24/2014)
What is the "machine in question"? The one the actual database is stored on?If so, then SSIS needs to be installed on the database server and also on each of the users' computers, correct?
Um, what? Why would your users need this installed?
SSIS' primary purpose is to perform behind the scenes ETL work. Your users shouldn't even know it exists other than in passing. What are your expectations here? In general, if your users are looking for information from the system, they should be going through an interface, not a design component. SSRS reports, cubes with powerpivot... something else, read only 99% of the time. SSIS should almost never be a user intitiated event, as it's far too easy for them to collide with each other depending on the design and expectations. applocks with jobs at the worst case scenario.
Otherwise you have to open up WAY too much security to an end user.
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