Alexander G. (6/2/2009)
Is it true that Standard Edition lacks the ftp task (if so: why is BIDS not giving a warning on this) or is the error caused by another error?
I'm not sure if the Standard edition lacks the FTP task. What i do know is that the BIDS is the same for all SQL Server 2005 editions and does not look at the server edition. I have had the same problem with the SSAS cube where i used functionality that would not deploy to a SQL Server 2005 SE server because it was only supported by the EE. BIDS never notified me until i tried to deploy. The same thing will happen if you use a fuzzy lookup task in a package and try to run it using the SE.
- Matthijs