Deployment Utility Error

Dec 19, 2005

I am getting the following error when trying to run a deployment
utility. The server only has .net framework 2.0 and sql server 2005
(rtm) installed.

If it's any help, this server was recently upgraded from the june ctp to rtm.

This is a production server, so a solution involving as little disturbance to it's current state would be preferrable.

Thanks in advance for any suggestions.

-Jeremy

TITLE: Package Installation Wizard

------------------------------

Unexpected error occurred.

------------------------------

ADDITIONAL INFORMATION:

Retrieving the COM class factory for component with CLSID
{E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
error: 80040154. (Microsoft.SqlServer.ManagedDTS)

------------------------------

Retrieving the COM class factory for component with CLSID
{E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following
error: 80040154. (Microsoft.SqlServer.ManagedDTS)

------------------------------

BUTTONS:

OK

------------------------------

View 5 Replies

Deployment 'utility' Script Using Sqlcmd

Jun 15, 2006

Hi all,

I'm looking at creating a sample utility script that will invoking
scripts to deploy some SQL code. For example, a utlity script that will
run a SQL script, and on successful completion, execute the next script.

Having not used SQLCMD at all before, and being very new to SQL2005
(< 1 month) please guide me if there is a better way of invoking
this... For example, a way of avoiding the xp_cmdshell invocation!

The following code invokes a script, but I'm trying to find a way of
getting a return code back from sqlcmd, so I can progress and do the
next, or fail if the return code <> 0 (success).

[code]

--Process to create DB, Tables, and Stored Procedures

set nocount on

DECLARE

@Error int,

@ExecCommand varchar(512),

@FullFilePath varchar(255)

--create the database

BEGIN TRY

SET @FullFilePath =
'D:DocumentationProjectsIntegration ServicesBIDS ProjectsTesco DNF
Integration ServicesTescoDNF ProductPromoSQL CodeOBJECTSCreate DB
TescoDNF_SSISPackageManager.sql'

SET @ExecCommand = 'xp_cmdshell ''sqlcmd -S RgalbraithSQL2005_1 -i "'+@FullFilePath+'"'' '

SELECT @FullFilePath

UNION

SELECT @ExecCommand

EXEC (@ExecCommand)

SELECT @@ERROR

SELECT @Error

END TRY

BEGIN CATCH

SELECT

ERROR_NUMBER() AS ErrorNumber,

ERROR_SEVERITY() AS ErrorSeverity,

ERROR_STATE() AS ErrorState,

ERROR_PROCEDURE() AS ErrorProcedure,

ERROR_LINE() AS ErrorLine,

ERROR_MESSAGE() AS ErrorMessage;

GOTO ErrorAbort

END CATCH

ErrorAbort:

[/code]

View 14 Replies View Related

Deployment Utility Or Import Package?

Jul 9, 2007

In reference to the question raised in this thread
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1460591&SiteID=1

Since I'm not able to create a deployment utility, when a config file is shared among multiple packages and also I cannot get the permission from Sys Admins to use Env. Variables I'm struck.

Now I'm thinking of importing the package to Sql Server from the file system. Is there any caveats in this approach? especially regarding the config files?

[edit]
Also, do I need any special permissions to view the Integeration Services node in Management Studio? We are using Integerated Authentication, neither do I'm able to run sp_start_job sp in the msdb database.
[/edit]

Thanks

View 1 Replies View Related

Security Required To Run Deployment Utility

May 18, 2007

I would like to have my developers responsible for deploying their SSIS packages to the Test/QA environment. I tried granting access to several of the stored procedures in msdb and the sysdtspackages90 table. The only thing that seems to work is granting sysadmin priviliges. Is there a server or database role that will grant the appropriate access? thanks

View 5 Replies View Related

How To Use Deployment Utility Using A Single Package Configuration File

Jan 22, 2007

Hi,

We are trying to create a deployment utility for a solution. The issue we are facing is, we are using a single package configuration file and when we try to build the solution to create the deployment utility, the build process fails saying that the package configuration file already exists. THe reason for this is while trying to build, the utility copies the configation fiel for the packages, it copies for one, but for the second onward, when it tries to copies, it fails saying the file already exists.

Any idea how to overcome this, or else any suggestions how to perform the similar steps to create a deployment utility for a solution in which the packages share a single package configuration file.

Any suggestion would be really appreciated.

Thanks in Advance,

Manish Singh

View 5 Replies View Related

SSIS Deployment Utility - Manifest Doesnt Show Up

Nov 19, 2007

When I create a deployment utility I...
- set AllowConfigurationChanges to True.
- set CreateDeploymentUtility to True
- DeploymentOutputPath is set to binDeployment
- I click 'Build' and it creates the binDeployment directory and writes all my DTSX files and my dtsConfig file
But it doesn't create a manifest file. Why not?
Thanks

View 2 Replies View Related

Errors During Building Project With Deployment Utility And Configuration File

Sep 28, 2005

I am getting following error when "CreateDeploymentUtility" is set to true and I try building the solution. It tries to copy a file that already exits in inDeployment folder. I am using Sept. CTP.

View 4 Replies View Related

SSIS Deployment Utility - Package Configurations Doesnt Show Up??

Jan 24, 2007

Hi:

After moving my deployment folder to the Target Server, I run the Installation Wizard. As I move next, I am missing the window which is supposed to allow me to set package config values as stated in MSDN:

"If the package includes configurations, you can edit updatable configurations by updating values in the Value list on the Configure Packages page."

Source: http://msdn2.microsoft.com/en-us/library/ms141802.aspx

Does anyone know why I am not seeing it? In my deployment bundle which I have moved over has currently 3 files:

1) SSIS Deployment Manifest

2) SSIS Package

3) SSIS Config File

Again, I double click on SSIS Deployment Manifest, and it starts fine. I go thru the steps for File System Deployment, and then it prompts for installation folder path. After that, it takes me directly to validation. Why is it not showing me the Configure Packages Page as described in the MSDN Documentation. Please advise. Thanks.

View 5 Replies View Related

Unable To Create A SSIS Deployment Utility For A Solution Which Are Having 2 Packages

Dec 28, 2007

Hi All,

I have created a solution which contains only 2 packages say Package1.dtsx and Pakage2.dtsx. I want to create a deployment utility to deploy onto other developers machince. I changed the project properties "CreateDeploymentUtility" to TRUE. When I do the build it is not creating the files in "Deployment" folder. It is saying Rebuild All Failed but the error is not showing.

For more information the 2 packages have 4 indirect configurations from environment variables which are storing the actual config file path.

Am I missing something here?

Thanks.
Venkat.

View 8 Replies View Related

Error With Rs.exe Utility

Feb 22, 2007

I'm getting some errors when I run rs.exe from command line with regard to Parameters, and was hoping I might get some help here. I'm somewhat new to RS. I'm running SQL 2000 and RS 2000 on a Windows 2003 Server.

Here is my script:
***********************************************************
' File: RunReport.rss
Dim format as string = "Excel"
Dim fileName as String = "C:Export2.xls"
Dim reportPath as String = "/APSAgentCourseCompletionByUserGroup"

Public Sub Main()

' Prepare Render arguments
Dim historyID as string = Nothing
Dim deviceInfo as string = Nothing
Dim showHide as string = Nothing
Dim results() as Byte
Dim encoding as string
Dim mimeType as string = "ms-excel"
Dim warnings() AS Warning = Nothing
Dim reportHistoryParameters() As ParameterValue = Nothing
Dim streamIDs() as string = Nothing
rs.Credentials = System.Net.CredentialCache.DefaultCredentials

' Report Parameters
Dim parameters(5) As ParameterValue
parameters(0) = New ParameterValue()
parameters(0).Name = "User Group"
parameters(0).Value = "66179312-f341-4df7-a855-79c5b8abaf9f"
parameters(1) = New ParameterValue()
parameters(1).Name = "Start Date"
parameters(1).Value = "12/22/2006"
parameters(2) = New ParameterValue()
parameters(2).Name = "End Date"
parameters(2).Value = "2/17/2007"
parameters(3) = New ParameterValue()
parameters(3).Name = "Course Name"
parameters(3).Value = "AA2B1AA0-E78A-4F84-834F-8EAAB75BEBD3"
parameters(4) = New ParameterValue()
parameters(4).Name = "Status To Include"
parameters(4).Value = "0"
results = rs.Render(reportPath, format, _
Nothing, Nothing, parameters, _
Nothing, Nothing, encoding, mimeType, _
reportHistoryParameters, warnings, streamIDs)

' Open a file stream and write out the report
Dim stream As FileStream = File.OpenWrite(fileName)
stream.Write(results, 0, results.Length)
stream.Close()

End Sub

'End of script
***********************************************************

As you can see, right now I've got all 5 report parameters hard-coded.

Here is the command line that I'm using as well as the error that I receive:

rs.exe -i c:RunReport.rss -s http://localhost/reportserver -t
Unhandled exception: The value of parameter 'Parameters' is not valid. Check the documentation for information about valid values.

Any insight that anyone can provide is greatly appreciated.

Thanks!

Ray

View 2 Replies View Related

Error While Running Bcp Utility

May 5, 2008

Hi all,

I m getting the following error while running the bcp utility.

Cannot insert null into column_name in table

something like this.

The value for that column is null in the input .csv file.

Instead of throwing error like this, i need those bad records should go in to the .BAD file and the remaining records should get uploaded into the database.

In my case the entire data upload is failing if any one bad record is there in the .csv file.

Can anybody help me. Its a bit urgent.

Thanks in advance,
Bharanidharan L

View 2 Replies View Related

Error When Using Rsconfig Utility

Aug 27, 2007

When i try to use the rsconfig utility to add the values to the

<UnattendedExecutionAccount>
<UserName></UserName>
<Password></Password>
<Domain></Domain>
</UnattendedExecutionAccount>

The WMI Provider returned an error: HRESULT=0x8004021D

View 5 Replies View Related

DTExec Utility Error

May 8, 2008

I HAVE an SSIS Pkg that gets data from lotusnotes into SQLS ERVER 2005. This SSIS Pkg works just fine, when I run it from manually from Visual studio environment. However, when I run this as a dtsexec from command line it fails with the foll error" The product level is insufficient for component "DataReader Source(1). The dtexec command I use is :

dtexec /f "c:otesPack.dtsx"

View 3 Replies View Related

Error Running SSIS Pkg From Dtexec Utility

Feb 21, 2008

Hi All,

I developed my package in BI studio and tested runnning it through BI. Now when i have to deploy the package to main server it will be executed via batch job. This package requires an input file name too.
Now when i am trying to run the package on my loacal box using following command on command prormpt i get error given below.

COMMAND USED BY ME: DTExec /FILE 'C:ProjectIntegrationServicesSFRIntegrationServicesinpkgSFRLocation.dtsx' /SET Package.Variables[InputParamFileName].Value;'C:DataDumpInputLOC00022'

ERROR MESSAGE:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 1:29:54 PM
Error: 2008-02-22 13:29:54.96
Code: 0xC0011007
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Unable to load the package as XML because of package does not ha
ve a valid XML format. A specific XML parser error will be posted.
End Error
Error: 2008-02-22 13:29:54.96
Code: 0xC0011002
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Description: Failed to open package file "'C:ProjectIntegrationServicesSFR
IntegrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The speci
fied path is invalid.". This happens when loading a package and the file cannot
be opened or loaded correctly into the XML document. This can be the result of
either providing an incorrect file name was specified when calling LoadPackage o
r the XML file was specified and has an incorrect format.
End Error
Could not load package "'C:ProjectIntegrationServicesSFRIntegrationServices
inpkgSFRLocation.dtsx'" because of error 0xC0011002.
Description: Failed to open package file "'C:ProjectIntegrationServicesSFRInt
egrationServicesinpkgSFRLocation.dtsx'" due to error 0x800700A1 "The specifie
d path is invalid.". This happens when loading a package and the file cannot be
opened or loaded correctly into the XML document. This can be the result of eit
her providing an incorrect file name was specified when calling LoadPackage or t
he XML file was specified and has an incorrect format.
Source: {9B1FAA88-A6FA-44CF-A2E2-DB3F737FDA65}
Started: 1:29:54 PM
Finished: 1:29:54 PM
Elapsed: 0.047 seconds

PLease let me know solution to creating batch job for executing this pkg with input param.

View 4 Replies View Related

DTExecUI - Package Execution Utility Error

Nov 7, 2006

Hi,

when i deploy my package using the DTExecUI thru the Package Execution Utility.when we execute the package . we are getting the following error.

The Product Levelis insufficient for component "Flat File Source(1)"

the package design is

FlatFileSource ----> OlEDBDestination

what could be the solution for this?

Thanks

Jegan

View 3 Replies View Related

May 16, 2007

Hi,

I get the following error when I am trying to deploy Report from Visual Studio Report Designer.
SRSS is configured in SharePoint integration mode. Configuration is mentioned below.

TITLE: Microsoft Report Designer
------------------------------

A connection could not be made to the report server http://rbddspsdev2:44887/.

------------------------------
ADDITIONAL INFORMATION:

Server was unable to process request. ---> The request failed with HTTP status 401: Unauthorized. (System.Web.Services)

------------------------------
BUTTONS:

OK

Configuration is as follows.

Web front end server.
MOSS 2007 Standard edition 64 bit.
SQL Reporting Service Add in 64 bit.

SQL Server
MS SQL server 2005 32 bit with sp2.
Reporting Services configured.
WSS 3.0 32 bit required for configuration, of SRSS in integrated mode.
Windows service and web service are both running under a domain account. The account is a SharePoint Admininstrator. The account is also in Administrators, Reporting Server user and Web service group and also has a dbo rights on database.

View 12 Replies View Related

Deployment And File System Error - Access Denied

May 16, 2008

We are setting up a new box and when we deploy the cube we are getting the error "File system error: The following error occured during a file operation: Access is denied. ."

We are part of an AD group that is a member of the administrators group on the box, and it looks like we have rights to the data directory where AS deploys cube data to. The account that AS service runs as is also an administrator on the box. It is a domain account. The cube does have one assembly - might that be the problem? We have set up a few boxes in the past without problems - we didn't have control over how this box was setup, so obviously we are missing a permission. If anyone has any insights / ideas, I'm all ears.

Thanks!
John

View 4 Replies View Related

Product Level Is Insufficient Error Message On Deployment Machine

Oct 10, 2006

Hi,

I have a SSIS package which I had created on my machine, running Windows XP with SQL2K5 Development Edition. If I run the package through the BI studio or by clicking the dtsx file, it runs without any issues.

When the same package is deployed onto another machine (SBS 2003 with SQL2K5 Workgroup Edition), the package errors with the above message when the dtsx file is clicked and run. However, if the source files are opened up and ran from within the BI studio, it all runs OK.

I've ran through the SQL setup file (through Add/Remove Programs) and Integration Services is installed, however the SSIS service is not on the machine. I've read however that the service is not required to run the package, so what gives? Plus, this doesn't explain why running it through BI studio is fine but not when run by itself.

The data flow task that the package fails on contains 2 SQL sources, 1 SQL destination, 3 sorts, 1 multicast and a couple of merge joins. Are some of these pieces not available in the Workgroup Edition? This would still not explain why it can run in the BI studio on that machine...

Any information provided would be great.

Regards

Alex

View 1 Replies View Related