Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Higher level edition required? Expand / Collapse
Author
Message
Posted Tuesday, June 2, 2009 8:46 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:41 AM
Points: 288, Visits: 301
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
Post #727475
Posted Tuesday, June 2, 2009 8:52 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:04 PM
Points: 23,302, Visits: 32,057
I'm thinking there is another problem. How are you trying to run the package on your server?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #727480
Posted Tuesday, June 2, 2009 9:26 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:41 AM
Points: 288, Visits: 301
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
Post #727511
Posted Tuesday, June 2, 2009 9:39 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:04 PM
Points: 23,302, Visits: 32,057
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.)



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #727528
Posted Tuesday, June 2, 2009 10:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 7, 2013 6:59 AM
Points: 22, Visits: 117
Hi,

username/password for ftp site should be in configuration file. I hope that I hit an answer
Post #727589
Posted Wednesday, June 3, 2009 1:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:41 AM
Points: 288, Visits: 301
Unfortunately there is no other error message in the screen log.
Post #727925
Posted Wednesday, June 3, 2009 1:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:41 AM
Points: 288, Visits: 301
I am using server storage and I am not using a config file.
Post #727926
Posted Thursday, June 4, 2009 5:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 18, 2013 1:45 AM
Points: 6, Visits: 98
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

Post #728818
Posted Wednesday, June 10, 2009 4:21 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, March 18, 2014 4:41 AM
Points: 288, Visits: 301
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...
Post #732117
Posted Monday, January 3, 2011 9:32 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:22 PM
Points: 354, Visits: 915
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



  Post Attachments 
SSIS_Errors.jpg (6 views, 62.97 KB)
Post #1041914
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse