Hi,

I have a package that contains an FTP task on SQL Server
2000 SP3.
I am trying to load the package from a console application
in C#. Following is the code.

############Code starts here###############################
Package2 p = new Package2Class ();
object o = null;
p.LoadFromSQLServer ("msdts002", "sa", "",
DTSSQLServerStorageFlags.DTSSQLStgFlag_UseDefault,
"", "", "", "FTPTask", ref o);
DTSFTPTask ftpTask = p.Tasks.Item (1).CustomTask as
DTSFTPTask;
Console.WriteLine (ftpTask.SourceSite);
Console.WriteLine (ftpTask.Name);

############Code ends here#################################

I am running this console application from Windows XP
machine.

When I do this, i get the following error:

UnSpecified error : 0X80004005

I am able to load all the other packages that contains
different tasks. But I am unable to load the package that
contains FTP task.

Any help would be greatly appreciated.

-Ram

In article <055401c3adc8$cf1d6360$a601280a (AT) phx (DOT) gbl>, Ram Mohan
<anonymous (AT) discussions (DOT) microsoft.com> writes
Do you have a reference to the Custom Task Library (custtask.dll)?

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org