|
LordOfflies
Starting Member
1 Post |
 Posted - 2009-04-23 : 01:43:07
|
| 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,messagePackageStart,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 of MS clearly states the SSIS runtime is included in all version of SQL Server 2008. |
|
SSIS runtime on SQL 2008 Web