March 14, 2006 at 9:30 am
Our clients don't use SQL Server for their data. But we anyway used DTS packages for transfering data between client's DB. Only thing that we needed to install was DTS dlls.
What will I need to do now to use old DTS and new SSIS packages on these clients?
March 15, 2006 at 2:16 am
Not quite sure what you mean by "clients". If you mean a remote database server to which you are transferring data then you don't need anything installed on them.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
March 15, 2006 at 2:42 pm
Yes. You are right. When I say "clients" I meen companies that use our applications. We give them some installation packages: 1 for server computer, 1 for its clients. Both these packages includes DTS dlls. So, either the client and server computers can execute DTS packages. And I don't have to install on each client and server DTS files.
Now, I want to know what I will have to do when I want to execute new SSIS and old DTS packages on these computers.
Will I have to go to each 500 computers and install SSIS runtime or I can put it inside of installation package?
Will SSIS runtime work if there is SQL server neither on server and client computers?
Will we have to buy licenses for each 500 computers or only for our development team?
March 15, 2006 at 2:52 pm
SSIS is not reliant on having SQL Server database engine installed.
If a machine is executing SSIS packages then it will require SSIS installing on it.
Can you put it inside an installation package? I don't know the answer to that one. I would assume so but I don't know how to do it.
Licensing - I have absolutely no idea.
-Jamie
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply