I have written a VB component to execute a SSIS package stored in SQL server.
I am using the Microsoft.sqlserver.dts.dtsclient, dtsconnection/dtscommand
and executereader and everything works perfect on the local machine. This is descibed in a msdn site .
But my customer have a remote SQL server and want no extra BI clients/SQL server clients etc on the client machine, only an ordinary windows client and network connection to the SQL server.
My question is: Can you still use dtsclient or do you have to do in some other way
rose-marie
execute SSIS package stored in remote SQL server from a client machine.
-Roel-
No, in this case there is a demand on a stand-alone windows application
without any dependencies other than oledb connections to SQL server.
Otherwise I would have liked a web service in the server machine or something like that, but...
rose-marie
RohitMehta802003
The whole idea was to run the VB component in a client machine without any extra i.e without SSIS.
I understand that this is not possible, is it possible to achieve this in another way
rose-marie
Roman H
It depends where your VB component is going to be running. You will need SSIS installed on the same machine.
-Jamie
CarolChi
Can you not run the component somewhere else