Re: SSIS package Excecution
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
Re: SSIS package Excecution
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.
Re: SSIS package Excecution
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