June 2, 2009 at 8:46 am
Hi,
When deploying a package with an ftp task to my server I get the above error although it runs fine in BIDS. I am using SQL Server 2005 Standard Edition and SSIS is installed on the server (at least I think so as I can deploy and run other packages and connect to SSIS on the server using SSMS).
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?
Regards
Alexander
June 2, 2009 at 8:52 am
I'm thinking there is another problem. How are you trying to run the package on your server?
June 2, 2009 at 9:26 am
I have saved a copy of the package to sql server using server storage protection level and executed the package from the ssis instance from within ssms.
The command line is:
/DTS "\MSDB\MYPACKAGE" /SERVER "MYSERVER" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V
June 2, 2009 at 9:39 am
So it looks like you are running it interactively. You need to review the ENTIRE on screen log. There may be other error messages that may help shed light on the problem, but they may be anywhere in the log. I had a problem with an SSIS package, and it took a bit to find the actual error message that told me what was wrong. (Not the same problem you are having.)
June 2, 2009 at 10:53 am
Hi,
username/password for ftp site should be in configuration file. I hope that I hit an answer 😀
June 3, 2009 at 1:11 am
Unfortunately there is no other error message in the screen log.
June 3, 2009 at 1:12 am
I am using server storage and I am not using a config file.
June 4, 2009 at 5:12 am
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
June 10, 2009 at 4:21 am
According to http://msdn.microsoft.com/en-us/library/ms143761.aspx the ssis differences between SE and EE are only a few tasks and transformations that have to do with term extraction, some fuzzy stuff and data mining.
No hint about an ftp task...
January 3, 2011 at 9:32 am
Hello SSIS Guru,
I am supputing a SQL Developer who run into problems on SSIS package.
The package returned an error (Please see the attachment) when he tried to execute in DOS prompt.
The Microsoft Visual Studio 2008 version 9.0.30729,4462 QFE.
In addition, the SSIS package was running fine in BIDS environment.
Would someone give me some hints and lights?
Thanks,
Edwin
January 4, 2011 at 7:37 am
I think it is best that you start up a new thread for this, as it has little to do with the original question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 27, 2013 at 8:08 am
When deploying a package with an ftp task to my server I get the above error although it runs fine in BIDS. I am using SQL Server 2005 Standard Edition and SSIS is installed on the server (at least I think so as I can deploy and run other packages and connect to SSIS on the server using SSMS).
I'm having the same problem when I try to run the job from the server. I'm using SQL Server 2005 Team Suite.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply