The Specified Package Could Not Be Loaded From The SQL Server Database

Hi all,

I have created a dts on my Sql server. which gets the data from my log file and insert into my sql 2005 table. In dts i am using 'Flat File Source' and 'SQL Server Destination'. When i execute this through 'SQL Server Business Intelligence Development Studio' it works good.

But when i execute this through my c# code from my web server, it throws me an error 'The specified package could not be loaded from the SQL Server database.'

This exception comes under app.LoadFromSqlServer.



My C# Code :



Application app = new Application();



Package package2 = app.LoadFromSqlServer("\Maintenance Plans\FTPPackage", "Server Name", "UserName", "Password", null);





DTSExecResult result2 = package2.Execute();

string str = result2.ToString();



I hv tried package name like '\Maintenance Plans\FTPPackage' and 'FTPPackage'.





Plz help me to solve this...



Thanks

Harsh