November 20, 2014 at 11:28 am
Can someone provide guidance on how to get SSIS set up? In order for an end user to use some of its functions, does something need to be installed on the db server itself, on the individual's computer, or both?
November 21, 2014 at 3:28 am
On every machine where you want to run an SSIS package, you need to install the Integration Services components, using the SQL Server media.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 21, 2014 at 5:20 am
This was removed by the editor as SPAM
November 21, 2014 at 5:30 am
jacksonandrew321 (11/21/2014)
Koen Verbeeck (11/21/2014)
On every machine where you want to run an SSIS package, you need to install the Integration Services components, using the SQL Server media.can't we run that SSIS through installed SQL Server ? Because when we connect to the database it gives options to connect to the SSIS as well.
SSMS will always give you that option, because you can also connect to remote SSIS servers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 21, 2014 at 5:33 am
If you don't have the Integration Services components set up on the machine in question, then SSIS won't work. Just because the Client Tools give you the option of logging into Integration Services, doesn't mean SSIS is set up properly.
The Client Tools just give you the option of logging into a machine where Integration Services is installed. That's it.
Business Intelligence Development Studio (aka BIDS, which is a crippled version of Visual Studio specificially for SQL 2008 and 2005 SSIS) is where packages are created. Then the packages need to be moved to a File Store or a SQL Server upon which SSIS has been set up. SQL Server stores the packages in MSDB. A file store could be a SAN attached to a SQL Server. Either way, if SSIS hasn't been set up, you can't move the packages up to the server.
BTW, SQL 2012 and 2014 uses regular Visual Studio for package creation.
November 21, 2014 at 5:35 am
This was removed by the editor as SPAM
November 21, 2014 at 5:41 am
jacksonandrew321 (11/21/2014)
so can't we use that SSIS funtions on that? If yes then its possible to use SSIS right from there.
I'll repeat it again:
if you want to use SSIS on a machine, you need to install Integration Services.
Period.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 21, 2014 at 5:51 am
Koen Verbeeck (11/21/2014)
jacksonandrew321 (11/21/2014)
so can't we use that SSIS funtions on that? If yes then its possible to use SSIS right from there.I'll repeat it again:
if you want to use SSIS on a machine, you need to install Integration Services.
Period.
Ditto. Ditto. Ditto.
November 24, 2014 at 10:16 am
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?
November 24, 2014 at 11:58 am
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?
No. Integration Services needs to be installed on the SQL Server Instance that you will use to run the SSIS packages.
Gerald Britton, Pluralsight courses
November 24, 2014 at 12:25 pm
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?
What are the users supposed to do with SSIS?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 2:45 pm
run some of the functions. Data profile viewer, for example.
November 24, 2014 at 2:54 pm
psc032802 (11/24/2014)
run some of the functions. Data profile viewer, for example.
In that case they will most likely need to install BIDS/SSDT. Not 100% sure, it's possible SSIS has to be installed as well for some of the extra functionality.
It's easy to test though...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 24, 2014 at 3:40 pm
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
December 1, 2014 at 11:00 am
the end users in this scenario are people wanting to run the data profiling features. my original question was what needs to be installed and where does it need to be installed in order for this to be possible?
1. does SSIS need to be installed on the server machine housing the database?
2. does SSIS need to be installed on the individual client machines wanting to run these functions?
Viewing 15 posts - 1 through 15 (of 41 total)
You must be logged in to reply to this topic. Login to reply