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


ADVERTISEMENT

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 - 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

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 View Related

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

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

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

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

Execute Package Utility

Oct 11, 2006

My SSIS package carries out one data flow task after another e.g.

truncate tables

Copy table 1

cleanup tables

When using the execute package utility in SSMS to run the package , the data flow tasks are listed alphabetically, so it reads:

cleanup tables

Copy table 1

truncate tables

Can I change this so the data flow tasks are listed in the logical order I have specified them in the package as it makes it difficult to work out which step the package is at. And while I'm at it, it keeps telling me every separate task's elapsed time is zero when it's finished. It records the start and end time ok, but it can't seem to work out the elapsed time?!

Thanks





View 1 Replies View Related

Execute Package Utility Issue

Oct 22, 2007

I created a package within BIDS which tests successful. However when saved into MSDB and I execute the package, the package completes without any issues however doesn't work.

All the package is doing is a simple backup and copy operation but fails without any errors within the Execute Package Utility.

Has anyone seen this issue before?

View 3 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

Error Executing SSIS Package With DTEXEC Utility

Feb 29, 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 8 Replies View Related

Execute Package Utility Has Encountered A Problem And Needs To Close

Jul 11, 2007

I'm a SQL Server 2000 user trying to get my head around v2005, in particular the changes from DTS to Integration Services.

I've build a few packages in BIDS and they work fine there, but saving them to either the file system or MSDB locations and running them in Management Studio results in:

Execute Package Utility has encountered a problem and needs to close. We are sorry for the inconvenience.

If I click on the debug button, I get this:

An unhandled exception ('System.IO.FileNotFoundException') occurred in DTExecUI.exe [404].

I've searched the Internet and found a few people who has also experienced this, but not received any answers.

Is there a kind guru out there with some idea of what is going on? Preferably something that doesn't involve re-installing, because the database has already been configured for our Blackberry users and I can't re-do it now.

View 1 Replies View Related

Dtexec Problem For Excel Source -- Runs Fine Using Execute Package Utility

Mar 3, 2008

I have this problem executing an SSIS pkg using dtexec.



dtexec /f d:smappsssis_pkgsdts_SOAR.dtsx /REP E





Code Snippet

Started: 10:28:58 PMEnd Error



Error: 2008-03-03 22:28:59.00

Code: 0xC0202009

Source: dts_SOAR Connection manager "SourceConnectionExcel"

Description: An OLE DB error has occurred. Error code: 0x80040154.

An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

End Error

Error: 2008-03-03 22:28:59.00

Code: 0xC020801C

Source: Data Flow Task Source - CHANNEL_DATA [1]

Description: The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC0202009.


Code Snippet







However, it runs fine when I double click the package and execute it using the Execute package utility. That really puzzles me.


The package transfers data from worksheets in excel to SQL Server 2005 DB.

Both source and destination are on the same system.
Please advise.

View 4 Replies View Related

Package Configuration Not Used After Deployment?

Mar 6, 2006

I've been searching for an answer to my question quite some time now and I've not been able to figure it out yet.

Situation:
- I've created a SSIS package containing a bulk insert task.
- I've added a package configuration containing the appropriate connection manager (i.e. dev, beta or live)
- CreateDeploymentUtility = true
- I've copied the deployment folder to our beta server and I started the manifest file to install the package to the sql 2005 server, after that I specified the config file location and changed the value so the approriate connection manager is used.
- When I execute the package from the sql server the package doesn't read the value from the xml config file, it uses the connection which was originally specified in the package, whereas when I run the package from my BIDS it is reading the value from the xml config file?

I can't seem to figure out why this is happening? am I missing something here?

Thnx.

View 1 Replies View Related

More Questions On Package Deployment

Apr 14, 2008

I'm slowing coming up to speed on configurations and deployment.

I have 2 questions for this thread.

Question 1:

When I create the deployment manifest (the file that gets created when I build) and then run it on the destination machine, there's a step in the wizard that asks for a folder location. The exact page on the wizard is called "Select Installation Folder", just to make it clear what I'm talking about.

What significance does this folder have? I noticed that when I was using the XML config option, the config file appeared there (and nothing else). When I use the SQL Server config option, I didnt see anything going into that folder. Are these the expected results in each case?

The description on that wizard page says, "The installer will install the SSIS package dependencies in the following folder." I'm not sure what this means and if I should expect more than the XML config file to appear in there (in the case when I used XLM config option). What are the "dependencies", other than the config file, that the wizard is saying that the folder will have?

Question 2:

I've been playing with deployment and there's a bunch of "play" packages that are on my test server. How do I clean these up?

View 10 Replies View Related

Package Deployment Question

Jun 18, 2007

Hi,



I have a standalone SSIS package that I wish to deploy from the file system, as opposed to SQL Server deployment.



Anyways, I was wondering if there's a command line utility for running SSIS packages on an ad hoc basis? What I was thinking was that I would put the call to the command line in a stored procedure using xp_cmdshell, so that the package can be called that way.



Am I thinking about this correctly?



Thanks

View 17 Replies View Related

Understanding Package Deployment

Apr 8, 2008

I went thru the online tutorial, but I was not able to finish "Deploying Packages Tutorial" because for some reason the sample packages they had use in the tutorial came up with errors when I added them to my project.

EDIT: See the following post for the trouble I ran into using the sample tutorial. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3145471&SiteID=1&mode=1

But I read thru the rest and I was able to get the gist of it and I did a simple example on my own.

And here are some questions.

In my example, I have one package that does a simple load from an XL spreadsheet into a database table. The package also writes some kickout rows (bad data) to a flat file. To keep the example simple, I configure just one value in the .dtsConfig file, and that is the server name.

Question:

(1) According to the tutorial, after I've created the deployment bundle I'm supposed to copy this over to the destination computer and run it there. Can't I just run it from my computer and choose where to install the package in the Package Installation Wizard? That's what I did and it worked and I am able to see the package on the target SQL Server. So, I'm wondering why I need to copy the demployment bundle to the target and run it there.

(2) In the Package Installation Wizard, there is a step called "Select Installation Folder". And the description on this page says, "The installer will install SSIS package dependencies in the following folder". Without knowing what this is going to do, I just picked a folder, and finished out the wizard. When I go and check that folder after the wizard is completed, I see that the .dtsConfig file got put there (on my local machine). What implication does this have? (I don't know how to schedule a job in SQL Server Agent, so I havent actually tried running the deployed package.) I'm going to guess the package is not going to run because the config file ended up in my machine.

(3) In my example, I could've also configured the connection string for the XL file and the flat file directory for the kickout data. But since the file names are a part of the connection string and the file names are likely to remain the same, but the directory locations may change, should I handle this with system variables? (Where the variable will contain the directory path only)

View 4 Replies View Related

SSIS Package Deployment From Vb.net

Feb 25, 2008

Hi all,

I am trying to write a simple application which simplifies package deployment to SSIS. Basically it allows one to select a folder which contains dtsx-packages and the it would upload those files to the MSDB in a folder of choice on the MSDB.
To do this I thought it would be nice to use the Integration Services API (Microsoft.SQLServer.Dts) and use the objects DTS.Runtime.Application and DTS.Runtime.Package.

The result would be this in a nutshell:
Dim dtsApp As New Dts.Runtime.Application
Dim pkg As Dts.Runtime.Package
pkg = dtsApp.LoadPackage(File.FullName, Nothing) --loading the package from the filesystem
dtsApp.SaveToSqlServerAs(pkg, Nothing, strPackagePath + PackageName, strDestinationServer, Nothing, Nothing)

However if I try to execute this the I end up with an Strace-assertion error.
Searching for that error lead me to the following post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2173800&SiteID=1

After some more research I found the cause of my problems. I only had SSMS (The workstation components) installed on my development-pc. Someone suggested that installing Integration Services would solve it and after testing this it indeed solved it, but this still didn't solve my problem. The tool I am writing is going to be used on production-workstations which only have the Workstation components installed and installing Integration Services there isn't likely going to happen. Mostly because having SSIS installed locally doesn't have a function; the packages will be deployed to a remote server right after they are loaded from the file.

Trying to find an alternative lead me to Dtutil which miraculously enough does seem to work if given the right parameters, but to me this feels like a dirty solution. I feel it shouldn't be necessary to resort to using System.Diagnostics.Process to manually start Dtutil in the background when I have this nice api specifically designed for SSIS.

Is there anyone here that has a suggestion or an idea how to deploy packages using the Dts.Runtime.Application without installing SSIS on my local workstation?

View 6 Replies View Related

SSIS Package Deployment With C# Problem

Jan 27, 2006

Hi,


I try to deploy a SSIS Package with the method SaveToDtsServer of Microsoft.SqlServer.Dts.Runtime.Application.


My C# project is to deploy a SSIS Package in a Setup Application (My project has a Installer Class).
It's work several times, but suddenly It stop working without change in my code.


There's a System.BadImageFormatException : Message="Invalid access to memory location. (Exception from HRESULT: 0x800703E6)"


Source="Microsoft.SqlServer.ManagedDTS"


StackTrace:


at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package
pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)

at TestPackageDeployment.Form1.button1_Click(Object sender,
EventArgs e) in
D:DEVTestPackageDeploymentTestPackageDeploymentForm1.cs:line 41




I try the SaveToSqlServer and SaveToSqlServerAs, but it doesn't Work, it's return the same exception. On the other hand, the method CreateFolderOnDtsServer works perfectly.





It' happen to me on a Win2003 and WinXp. I Use SQL Server 2005 + VS 2005.





here is my code :





using System;


using System.Collections.Generic;


using System.ComponentModel;


using System.Data;


using System.Drawing;


using System.Text;


using System.Windows.Forms;


using Microsoft.SqlServer.Dts.Runtime;


using Microsoft.SqlServer.Management.Smo;


using MSDR = Microsoft.SqlServer.Dts.Runtime;


using Microsoft.SqlServer.Management.Smo.Agent;





namespace SSIS_API


{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

}




private void button1_Click(object sender, EventArgs e)

{




Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();







Package pkgSSIS = new Package();

pkgSSIS.Name = "Integration";




try

{

//app.SaveToSqlServer(pkgSSIS, null, "BGSXP-267", null, null);

app.SaveToDtsServer(pkgSSIS, null, @"File SystemmyPackage", "BGSXP-267");

}

catch (Exception err)

{

MessageBox.Show("Erreur : " + err.StackTrace.ToString());

}

finally

{

this.Close();

}

}

}


}

View 7 Replies View Related

SSIS Package Deployment In Different Environment

Sep 21, 2007



Hi, All,

I am using Package Configuration to simplify SSIS package deployment process. All the configuration information are stored in XML file. So far so good, However, since I have many, 20, packages. For each package, there is one configuration file to it. During the deployment process, I have dynamically modify connecting string (server name, DB name) to new ones. It ends up 20 or more modification and it's eaily for me to make mistake. Is there any workaround such as setting up environment variable, I guess, to allow me only modify once and apply it to all the packages?

TIA,

John

View 5 Replies View Related

SQL Deployment / Production Package Versioning

Jan 10, 2006

For the past few months I've been developing an DW and ETL with SQL
2005 / SSIS.  My packages are being deployed to a SQL
Server.  Although in the end game we will have a
Dev/Staging/Production environments, I would still like to archive
production packages when we push staging to production. 
Essentially I would like to archive the last X packages that were
deployed to production where X is a reasonable number (3 - 5).  I
don't necessarily need to have them accessible to run.  One of the
purposes is to have another safeguard should we miss anything in user
testing and need to roll back a deployment.



I am utilizing VSS and we will have backups running on the production
server, but I would prefer to have a archive that is a little more
accessible.



I just wondering if anyone has any thoughts on how to extract/archive
production packages when the push is made.  I could easily develop
an app that queries the MSDB and exports the packages to the file
system. 



Anyone have any thoughts?



Larry Pope

View 2 Replies View Related

SSIS Package Deployment To Msdb

Feb 27, 2006

I have designed a few SSIS packages in the BI Development studio and deployed them to the msdb database of my SQL server using the generated Deployment Utility.

They deployed and executed just fine, but, I would like to better organize them into folders within the msdb storage area.

Is there a way to tell the project or the generated Deployment Utility to deploy the packages to a specific folder within the SSIS Packages / msdb storage area on the SQL server?

Thank you for any help!

-Tim

View 4 Replies View Related

2 Configurations Files In The Deployment Package ?

Apr 9, 2007



Hello,



I have two SSIS packages in the same project with, for each one, a (XML) configuration file.



I have created a Deployment Utility file (.SSISDeploymentManifest).



My problem is that, when I execute that utility file, I can't deploy more than one configuration file, the UI only ask for one.



Is anyone can help me ?

Thanks a lot.



Alexis

View 1 Replies View Related

MSDE Included As Part Of ASP.NET Deployment Package?

Nov 17, 2003

I need to design an asp.net application w/ and MSDE backend database that will be deployed at 50 different location (unrelated to each other). The application's deployment package needs to be downloaded from a web site on the internet. The end user locations do not have SQL2000 or MSDE...some have access.

I want to know if my deployment package can include the MSDE software? Or, can anyone offer ideas on the EASIEST way for these small offices to get MSDE installed on each of their servers so that my ASP.NET applications will connect to via ado.net.

Thanks for any ideas.

View 1 Replies View Related

Deployment Package Failure - Could Not Copy File

Jan 18, 2008

Trying to build a deployment package. I have a number of dtsx in a project that share a connection config file. When I build, the error states: 'Could not copy file "whatever.dtsconfig" to the deployment utility output directory. ... The file already exists'

What am I doing wrong?

View 7 Replies View Related

SSIS Package Deployment/Last Update Date

Dec 5, 2007

Hi,

Is it possible to determine the date a SSIS package was last updated?

Our packages change on a regular basis so being able to determine the date that it was last updated is very useful. I can only find the creation date.

Cheers,
Melissa

View 1 Replies View Related

Unusual Behavious Of An SSIS Package While Deployment

Feb 7, 2008


This is regarding one package where we are trying to deploy the package through €œSql Server deployment€? using .dtsx, .dtsConfig and manifest files, but after deployment the package is not found in €œmsdb€?. Instead it is reflecting in €œfile system€? folder. The same behavior is observed repeatedly when we tried to deploy the package.

We have seen such behavior only in this package. Please help us in solving the above scenario.

View 1 Replies View Related

Package And File Location Dependencies On Deployment

Sep 12, 2006

My parent package calls packages stored in the file system. While developing, I would like to call packages in the project bin directory. In production, I would like to call packages in a different development. Is this possible?

I can change the package connection string with an expression that refers to user variables PackageLocation1 or PackageLocation2. I would like to do this automatically. Is this something that should be done at deployment time? Or is there a run time value that I can check and conditionally use PackageLocation1 or PackageLocation2?

Development and deployment is done on the same server, so the same enivronment variable value would be used in an indirect configuration. Same thing applies to a file configuration.

Another question: Is it possible to set up a different Installation Folder for use during deployment? Every time I deploy, I have to navigate the folders, you can't even paste in the folder name.

View 4 Replies View Related

Property Values Cleared After Package Deployment

May 14, 2008

I have a very odd problem. I have a package which uses some custom tasks that were written in C#. When the package is deployed to our production server, *some* of the property values for *some* of the tasks are cleared. For example, I have these five tasks:

FP Export File Logger
FP Import File Logger
FP Import Table Logger
FP Instance Logger
FP Job Reader

All of them inherit (of course) from Microsoft.SqlServer.Dts.Runtime.Task. All of them have custom members (some similar, some different), and of course, different implementation (though they are mostly the same). This test package has one instance of each of the different tasks.

As I said above, when we deploy to our production server, *some* of the property values for *some* of the tasks are cleared -- but when deployed to our dev server, everything remains intact.

Here is what is cleared:

- On 4 of the 5 tasks, the Description property (inherited by Task) is cleared, but the other one remained intact
- On 3 of the 5 tasks, the Connection property (custom property in all tasks) is cleared, but the other two remained intact
- 3 of the tasks have other string properties that were set, and all of these were cleared

We can reproduce this on two different production servers, and these two servers have some different configurations, suggesting these would not be the culprit:

- They have different service packs (one is build 2047, the other build 3042)
- One has the custom SSIS components installed (in the GAC), the other one does not

Our development server, where the package is deployed as expected, has build 2047 w/ the components installed.

Here are the packages, where you can compare and see the differences (using a text comparison tool):

Dev-GOOD.xml
Prod-BAD.dtsx

These were created after being deployed by importing within a Visual Studio SSIS project from the server.

Any suggestions would be *greatly* appreciated, as we are totally stumped as to why this is happening.

EDIT: Additional clues, this package is deployed to the MSDB. If it's deployed to the File System, it remains unmodified.

Thanks in advance.
Jerad

View 2 Replies View Related

Connection Manager Deployment With Master/detail Package

Dec 15, 2006

Hallo,

I'm currently strugling with the setup of our packages for deployment to a new environment.

We are working with a master/detail package setup. One master package is created that will call all child packages. In the master package we don't have any connection towards our source and/or target databases/sourcesystems.

Everything works fine, however, starting to deploy the whole set of packages, it seems that we don't have the option to set specific properties of our detailed packages, e.g. connection properties. But this is just what we need.

When we are adding a job in the Job Agent for our master package to be scheduled, we want to be able to set all different connection manager properties, not only the one from the master package and definitely the ones from the detailed packages as there we switch the connections from the development environment towards the acceptance environment.

I tried to fix this with parent package variables, but I can't set the password property, only the ServerName and UserName can be set, not the Password.

Anyone an idea what the easiest and best approach is to solve this burden?

Thx

View 1 Replies View Related

Login Timeout Expired Prevents Package Deployment

Aug 22, 2006

I'm trying to deploy an SSIS package to a server ("SQL Server" deployment). The package does have an encrypted password, which has both worked nicely and not in the past. It's entirely possible that our other "DBA" has busted something on the server, thus preventing my access to it, but I'm curious if anyone has any experience w/ error code 0x80004005 (Login timeout expired) in the SaveToSqlServer method.
Is that just the generic you-can't-log-in message, or is it really trying to imply that the SQL Server is not responding to login attempts?Thanks for any help, Ben

=================================== Could not save the package "C:Documents and SettingsfooarinDeploymentfoo.dtsx" to SQL Server "BAR". (Package Installation Wizard) =================================== The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed. ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword) at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames) at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs) =================================== The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired). The SQL statement that was issued has failed.------------------------------ Program Location: at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword) at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved