SSIS package Excecution

[mrx3cas]

Hi,

I want to execute a ssis package from vb.net application.

I am getting the following error while calling a ssis package from vb.net application.

The specified package could not be loaded from the SQL Server database

ssis package is working fine from BIDS as well as from SQL Server Management Studio (SSMS).

Package is deployed to the File System of SSMS.

I am using the following code.

Code:

app.LoadFromSqlServer("\\MData_import", "70.50.30.891\SQL2005", Nothing, Nothing, Nothing)

where app is the Microsoft.SqlServer.Dts.Runtime.Application object and MData_import is the package name.

There is no password set for the package.

Please help me to resolve my issue.
Thanks in advance.

[Craig Gemmill]

Just to confirm, you have deployed the package to the filesytem OR SSIS?

See this article for an example of what I'm talking about:
http://technet.microsoft.com/en-us/l...sqlserver.aspx

[mrx3cas]

Hi,

My SSIS package is deployed to MSDB location of the SQL2005.

Now I am able to execute the ssis package from the application in my PC.

But here I am facing one more issue.i.e.
The same application not working in another PC in which no SQL server environment is there.

In my PC SQL server2005 server is installed.

I am using one library in my application for calling SSIS package.
i.e.Microsoft.SQLServer.ManagedDTS.dll

I copied the same library in to the same location of the new PC in which I want to execute.

Assembly location
-----------------------

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies\Microsoft.SQLServer.ManagedDTS.dll

But still I am getting error.

How to execute the same application in that new PC?

Thanks in advance.

[dglienna]

Map the location. Refer to it as \\myShare\Folder\myfile.dll
to the location it is working on the first pc. Probably in the SQL related folders