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 |
|
sanghavi17389
Starting Member
26 Posts |
 Posted - 2013-01-19 : 00:48:20
|
| hi,I have made a code in wcf service which i host as a service on that machine where BI is installed.my code is: package = app.LoadPackage(@"D:\CloudAmber\Icarus\CloudAmber.DataWarehouse\Harshal\testRecordCount\testRecordCount\Package.dtsx", null); package.ImportConfigurationFile(@"D:\CloudAmber\Icarus\CloudAmber.DataWarehouse\Harshal\testRecordCount\testRecordCount\BasicConfig.dtsConfig"); package.InteractiveMode = true; //Execute DTSX. Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute(); it does not show error but my package can not run from remote machine.Locally it works fine.Any suggestion regarding user permission or code?harshal sanghavi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-19 : 02:46:18
|
| are both machines in same domain? is login configured for access in integration services instance?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sanghavi17389
Starting Member
26 Posts |
Posted - 2013-01-19 : 04:29:27
|
yes both are in same. and user name is configured as admin. One more thing, in local machine, integration service is not installed. I want to use without installing it.quote:
Originally posted by visakh16
are both machines in same domain? is login configured for access in integration services instance?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
harshal sanghavi |
|
|
|
|
|
|
Need to Execute package from remote pc