April 22, 2009 at 11:44 pm
Hello,
we have several servers running SQL Server 2005 Standard as shards for user data.
We want to swap to SQL Server 2008 Web for the lower license cost.
We installed a "test" and when i'm trying to run a SSIS package with the SQL Agent (job) i get the following error:
#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
PackageStart,E1DBA09,E1DBA09\srvsqle1dba09,Package,{992B5986-1B49-4FC4-845D-FA408E9DB3D0},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:54 PM,4/21/2009 3:04:54 PM,0,0x,Beginning of package execution.
OnPostExecute,E1DBA09,E1DBA09\srvsqle1dba09,Prepare Files To Drain,{5F2C577B-C6BE-4044-A22C-A33EFC6A4636},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,0,0x,(null)
OnPostExecute,E1DBA09,E1DBA09\srvsqle1dba09,Prepare All related data for draining,{596C80ED-24CB-4903-9A98-E10C612D2199},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,0,0x,(null)
OnError,E1DBA09,E1DBA09\srvsqle1dba09,Parent File Safes,{1AAEEEE3-E7BB-4AE4-B8C5-1D0D125EE1EE},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
OnError,E1DBA09,E1DBA09\srvsqle1dba09,Package,{992B5986-1B49-4FC4-845D-FA408E9DB3D0},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
OnError,E1DBA09,E1DBA09\srvsqle1dba09,Parent File Safes,{1AAEEEE3-E7BB-4AE4-B8C5-1D0D125EE1EE},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
OnError,E1DBA09,E1DBA09\srvsqle1dba09,Package,{992B5986-1B49-4FC4-845D-FA408E9DB3D0},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
OnError,E1DBA09,E1DBA09\srvsqle1dba09,Parent File Safes,{1AAEEEE3-E7BB-4AE4-B8C5-1D0D125EE1EE},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
OnError,E1DBA09,E1DBA09\srvsqle1dba09,Package,{992B5986-1B49-4FC4-845D-FA408E9DB3D0},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
OnPostExecute,E1DBA09,E1DBA09\srvsqle1dba09,Parent File Safes,{1AAEEEE3-E7BB-4AE4-B8C5-1D0D125EE1EE},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,0,0x,(null)
OnPostExecute,E1DBA09,E1DBA09\srvsqle1dba09,Package,{992B5986-1B49-4FC4-845D-FA408E9DB3D0},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,0,0x,(null)
PackageEnd,E1DBA09,E1DBA09\srvsqle1dba09,Package,{992B5986-1B49-4FC4-845D-FA408E9DB3D0},{37F31F9B-E1CE-4668-A599-FD2ED7E011E0},4/21/2009 3:04:55 PM,4/21/2009 3:04:55 PM,1,0x,End of package execution.
As you can see, some steps in the package work and on others it states that the version is incorrect!
Any workaround to this? We need these packages to drain the shard data to the "Archive".
SQL Server 2008 SP 1 is applied on the server.
The product information clearly states that the SSIS runtime is included in all versions of SQL Server 2008.
December 8, 2009 at 8:47 am
Hi there ...
I am experiencing the exact same problem.
Initially when I executed dtexec.exe the following message was returned:
The SQL Server Execute Package Utility requires Integration Services to be installed by one of hese editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.
I was able to overcome that by installing the SQL Server 2008 SP1. Installing Integration services is not an option due to the licensing cost.
Now it seems that there are only certain components that cause th following message to be returned:
OnError,,,,{E63C6254-8E07-42EB-B449-55C2050D3A90},{F8AC4BDB-5CB4-4344-8CBC-892BF1F84C46},2009/12/08 04:26:14 PM,2009/12/08 04:26:14 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
In this case the source of the error seems to be a Send Mail Task.
Have you or anyone else have any information on how I may resolve this issue?
Thanks
December 8, 2009 at 10:55 am
we have several servers running SQL Server 2005 Standard as shards for user data.
We want to swap to SQL Server 2008 Web for the lower license cost.
We installed a "test" and when i'm trying to run a SSIS package with the SQL Agent (job) i get the following error:
As you can see, some steps in the package work and on others it states that the version is incorrect!
Any workaround to this? We need these packages to drain the shard data to the "Archive".
SQL Server 2008 SP 1 is applied on the server.
The product information clearly states that the SSIS runtime is included in all versions of SQL Server 2008.
I don't know where you got that information SQL Server Express never comes with SSIS and the Workgroup edition SSIS is just admin even in 2005. So here is the features comparison link and the Web edition does not come with SSIS either designer or runtime.
http://msdn.microsoft.com/en-us/library/cc645993.aspx
Kind regards,
Gift Peddie
December 8, 2009 at 11:00 am
Cyclone (12/8/2009)
Hi there ...I am experiencing the exact same problem.
Initially when I executed dtexec.exe the following message was returned:
The SQL Server Execute Package Utility requires Integration Services to be installed by one of hese editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.
I was able to overcome that by installing the SQL Server 2008 SP1. Installing Integration services is not an option due to the licensing cost.
Now it seems that there are only certain components that cause th following message to be returned:
OnError,,,,{E63C6254-8E07-42EB-B449-55C2050D3A90},{F8AC4BDB-5CB4-4344-8CBC-892BF1F84C46},2009/12/08 04:26:14 PM,2009/12/08 04:26:14 PM,-1073679321,0x,To run a SSIS package outside of Business Intelligence Development Studio you must install Standard Edition of Integration Services or higher.
In this case the source of the error seems to be a Send Mail Task.
Have you or anyone else have any information on how I may resolve this issue?
Thanks
The send mail task takes an SMTP connection so if you don't want to pay for SSIS license you need to look for existing code that can send mail in your web application. Web.Config system.net entries required which you can get from your hosting provider.
http://msdn.microsoft.com/en-us/library/ms142165.aspx
Kind regards,
Gift Peddie
December 8, 2009 at 9:52 pm
Hi ...
Thanks for the responses.
It seems that SQL 2008 SSIS has had a number of changes to the behavior of its components. This is quite a departure from the way they functioned previously in SQL 2005 SSIS.
Using the dtexec.exe, I am able to execute some tasks in an SSIS package, such as Data Flow, Execute SQL, Logging to txt and using config files, so it seems that some of the components work fine without Integration Services being installed. So far, I have not seen a single occasion, in my testing, where the MsDtsSrvr.exe actually did any processing, even for the Send Mail Task. I have run the packages through dtexec.exe while having SQL Server Integration Services 10.0 service disabled and stopped.
Does anyone know of any official information regarding these issues?
What are the SSIS tasks that one may continue to execute through dtexec.exe without having Integration Services installed?
December 9, 2009 at 12:10 am
Gift Peddie (12/8/2009)
we have several servers running SQL Server 2005 Standard as shards for user data.
We want to swap to SQL Server 2008 Web for the lower license cost.
We installed a "test" and when i'm trying to run a SSIS package with the SQL Agent (job) i get the following error:
As you can see, some steps in the package work and on others it states that the version is incorrect!
Any workaround to this? We need these packages to drain the shard data to the "Archive".
SQL Server 2008 SP 1 is applied on the server.
The product information clearly states that the SSIS runtime is included in all versions of SQL Server 2008.
I don't know where you got that information SQL Server Express never comes with SSIS and the Workgroup edition SSIS is just admin even in 2005. So here is the features comparison link and the Web edition does not come with SSIS either designer or runtime.
Well, the original page did say that it was included. We opened a call to MS and they "investigated" the issue.
The result was they changed there page ...
December 9, 2009 at 12:56 am
Hi,
check http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
on integration services. Web edition has limited functionality.
If upgrading SSIS from sql 2005 to sql 2008 you will need to upgrade the packages from B.I. Development Studio
Vasilis
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply