sql express does not have integration services.
dtutil does not work without integration services. This is therefore not an option.
The deployment manifest needs dtutil to execute. This is also not an option.
The documentation on microsoft states that a person can connect to remote integration services by editing the ini file and then connecting locally.
http://msdn.microsoft.com/en-us/library/ms137789.aspx. Without integration service, one can not connect locally to integration services so using the transfer package of sql server is
also not an option.
Also connecting remotely to an integration without editing the ini seems to require local admin rights on the target server. This is a bit too much to ask. (this is what I experimented let me know if you know the exact requirements)
Is there a possibility for a person with sql express, without local admin rights to the target server, to push his ssis to his sql server test instance?
View Complete Post