Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
conradao.co.za
Starting Member
6 Posts |
 Posted - 2010-12-07 : 03:04:38
|
| If all the data is on a SQL server, and I designed the SSIS packages on my local PC, where does processing happen on the server or the my PC,...what I am trying to ask, must I remote to the server and run the packages from there |
|
|
dbird
Starting Member
4 Posts |
Posted - 2010-12-07 : 11:11:41
|
| If you run the package on your PC then it is remotely accessing the data. SSIS is a service that is installed on your PC, if it was not installed you would not be able to execute the SSIS package on your PC. To run a package on a server the packge must exist on the server. It can be scheduled through SQL Agent or run manually which logged on to the remote server. |
 |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-07 : 11:16:56
|
| It's a client app so runs on the machine it is executed on.Actually the package di=oesn't need to exist on the server to run there - you just need to execute the dtexec command on that server - it can load the package from anywhere.When you debug the package in BI studio it doesn't need the server installed - when you deploy and run it the machine that it is executed on does need the licence and run time installed.? Why does SSIS need a sql server licence and why is it distributed with sql server?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
SSIS processing