I am fairly new at this SqlServer (have many years as Oracle DBA behind me)
so my question may sound naive. I am using the SqlServer Mgmt. studio and I
do not see how to edit/maintain packages. How do I install SSIS on the server
where SqlServer is running. I have all the privileges afforded by my Windows
login on that server. Thank you.
"Darren Green" wrote:
> You need to install SSIS on any machine upon which you wish to run packages.
> BI Development Studio includes it's own host for debugging SSIS, which is not
> the same as running a package as you would in a non-development scenario.
> Also be aware that SSIS does not have any remote execution feature, or
> client redistributable, so when you load and execute a package in code, the
> package will run on the same machine as the calling code, so Server2 needs to
> have SSIS installed as that it is where it is trying to run.
> --
>
http://wiki.sqlis.com |
http://www.sqlis.com |
http://www.sqldts.com >
>
> "zhengj@ciac.sh.cn" wrote:
>
> > I use
> > Microsoft.SqlServer.ManagedDTS;Package.LoadPackage;Package.Execute();to
> > load dts(ssis).The sqlserver&SSIS (on server1) not the same sever
> > with the application(on server2).I load from file type
> > Package(dtsx),because I want to outport data to a local access mdb(on
> > server2).
> > I install a managestudio and some tools (no instance and no SSIS) on
> > the server2 for the runtime.but if I donot install SSIS on
> > server2.then i run the application ,the Package.Execute() result is
> > failure.And if I install a SSIS on server2,the same application can
> > success.I donnot know which I do wrong.The dtsx can run success in BI
> > developer studio(ssis project) on server2 without SSIS installed.
> > maybe express not so clear.but I really need help.thanks for giving me
> > advice.
> >
