Isues with deploying SQL Server 2008 R2 SSIS package to SQL 2008 server

• PSB

  SSChampion

  Points: 13195

  More actions

  May 2, 2012 at 11:00 am

  #255733

  Hi,

  I deployed my packae to QA and STG server without issues but wen I deploy to Production I get the following error message .

  "The Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008 R2 , Standard,Enterprise,Developer , or Evaluation. To install Integration Services , run SQL Server Setup and select Integration Services."

  We have other SSIS packages running from this Production server . Not sure what exactly is causing this issue.I donot have any ADO.NET components in my package as well..

  Please help.

• BudaCli

  Hall of Fame

  Points: 3404

  More actions

  July 6, 2012 at 3:18 am

  #1509543

  I also got error below:-

  "The SQL Server SSIS Package Utilities require Integration Services to be installed by one of these editions of SQL Server 2008:

  Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services."

  but I then saw this link:-

  http://support.microsoft.com/kb/963070

  and I am busy trying to see if I can resolve

  What you don't know won't hurt you but what you know will make you plan to know better

• BudaCli

  Hall of Fame

  Points: 3404

  More actions

  July 6, 2012 at 3:28 am

  #1509544

  Still does not work. I've got 2008 packages and I want to import them to SQL 2012.

  What you don't know won't hurt you but what you know will make you plan to know better

• BudaCli

  Hall of Fame

  Points: 3404

  More actions

  July 6, 2012 at 5:33 am

  #1509612

  Got it got it got it....

  The error means that there something that you didn't install and below is the script that I used to import packages within SQL:-

  NB: xp_cmdshell shold be enabled and path for your source of your packages should be changes from D:\packagePATH\SSIS\ to wherever your packages are stored.

  DECLARE @loop TABLE (ID INT IDENTITY(1,1), SUBDIR CHAR(200), depth INT, [file] INT)

  DECLARE @Updatedloop TABLE (ID INT IDENTITY(1,1), SUBDIR CHAR(200))

  DECLARE @pathCHAR(50) = 'D:\packagePATH\SSIS\',

  @aINT = 1,

  @zINT,

  @sqlVARCHAR(1000),

  @PackageNameVARCHAR(200)

  INSERT@loop

  EXEC master.dbo.xp_dirtree @path = @path, @depth = 0, @file = 1

  INSERT@Updatedloop

  SELECTSUBDIR

  FROM@loop

  WHEREREPLACE(RTRIM(SUBDIR), '.dtsx', '') NOT IN (SELECT LTRIM(RTRIM(name)) FROM SrvName.msdb.dbo.sysssispackages) --Do not import duplicates

  SELECT@z = MAX(ID)

  FROM@loop

  WHILE @a <= @z

  BEGIN

  SELECT@PackageName = RTRIM(SUBDIR) FROM @Updatedloop WHERE ID = @a

  SELECT@sql = 'xp_cmdshell ''dtutil /FILE "D:\packagePATH\SSIS\' + RTRIM(@PackageName) +

  '" /DestServer SrvName /COPY SQL;"' + REPLACE(RTRIM(@PackageName), '.dtsx', '') + '"'''

  PRINT '--Importing package ' + RTRIM(CAST(@a AS CHAR(4))) + ' of ' + RTRIM(CAST(@z AS CHAR(4))) + ' [' + @PackageName + ']'

  --PRINT @sql

  EXEC(@SQL)

  SELECT@a = @a + 1

  END

  What you don't know won't hurt you but what you know will make you plan to know better