SSIS Deployment On Sql Cluster Problem

Nov 9, 2007

Hi,

I have been battling the whole day to get my project working on our sql cluster.

My project contains file system packages parent(control) packages etc. I cannot get any package to execture after deploying and configuring the packages with the manifest.

When I try to execute even a simple package, i get the following error:

Date,Source,Severity,Step ID,Server,Job Name,Step Name,Notifications,Message,Duration,Sql Severity,Sql Message ID,Operator Emailed,Operator Net sent,Operator Paged,Retries Attempted
11/09/2007 15:06:59,SGA Staging ETL import,Error,0,BRY-CLUSSQL-1,SGA Staging ETL import,(Job outcome),,The job failed. The Job was invoked by User sgainterface. The last step to run was step 1 (Test).,00:00:00,0,0,,,,0
11/09/2007 15:06:59,SGA Staging ETL import,Error,1,BRY-CLUSSQL-1,SGA Staging ETL import,Test,,Executed as user: SUPERGRPSvcSQL. ...on 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:06:59 PM Error: 2007-11-09 15:06:59.45 Code: 0xC0011007 Source: {8B6231A9-8E5B-47BC-B54F-6A448B93B085} Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error Error: 2007-11-09 15:06:59.45 Code: 0xC0011002 Source: {8B6231A9-8E5B-47BC-B54F-6A448B93B085} Description: Failed to open package file "\10.202.29.35SGA Import ConfigsSGA Staging Deployment PackagesActive PackagesSGA ETL Step 1.1 - Prepare Branch Master File.dtsx" due to error 0x80070005 "Access is denied.". 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 or the XML f... The package could not be f... The step failed.,00:00:00,0,0,,,,0

Has anyone ever gotten this error? Is it permission related? I have already granted the sql user for this project ownership over the database but I think that the agent does not have permission to access those file system packages. This might be a problem since it is a file system package...if so, how do I grant the agent access to an NT file system?

Regards

View 3 Replies


ADVERTISEMENT

SSIS File System Deployment Vs SQL Server Deployment

Aug 15, 2007

Hi,


Please can you let me know which of the following 2 is a better method to deploy SSIS packages

File System deplyment OR SQL Server deployment

What are the advantages of one over the other?

Thanks,
Mrinali

View 4 Replies View Related

How SSIS Works With Cluster SQL And Non Cluster SSIS Service?

Mar 14, 2008



According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED.
http://msdn2.microsoft.com/en-us/library/ms345193.aspx

Now this is the situation that I have where I need to understand how SSIS works?

Enviornment: Active Active cluster enviornment for SQL server with SSIS server installed as stand alone as default on both node.


Name: Node 1 Node 2
--------- -------------- ---------------------
Server name: Nd1 Nd2
SQL server name: cs-nd1in01 cs-nd2in02
SSIS server name: Nd1 Nd2

BTW, this is cosolidated enviornment so there are more than one application expected and resides on each instance of SQL server.

The question is around SSIS, what would be the best practice to develop SSIS package that can work with above envoinrment.

Secnario: What if my Nd1 fails. SQL server cs-nd1IN01 will be failover to Nd2 and it will be available. But How about SSIS packages? How that understands
to use Nd2 SSIS as Nd1 SSIS is not available. Is anyone has similar experience to setup SSIS in cluster envionrment but as non-cluster service?

Please help. Thanks in adavance.

View 1 Replies View Related

SSIS Deployment

Sep 13, 2007

Is there a way that would allow me to deploy ssis for end user in a given file, where the end user simply clicks some icon that will tiger the ssis deployment process?

View 2 Replies View Related

Ssis Deployment

Oct 19, 2007

Hi All,
I am able to execute my ssis package from BID environment using SQL Server Authentication. However, when I deploy the package on SQL Serve 2005 using Windows Authentication, the package fails. The package is a simple one, it read two servers, truncate tables and load the data on the destination server.

I am not sure why this fails when I execute the package on the server environment, but works fine when I run it from BID.

Any help would be greatly appreciated.

Thanks

View 4 Replies View Related

SSIS Deployment

Mar 11, 2008

Hi

I am looking at deploying some ssis package's as files, my question can I install just integreation services on on server to run the packages or do I need the full installation of sql server 2005

Bimal

View 4 Replies View Related

SSIS Deployment

Jun 1, 2006

Hi,

I would like to deploy my SSIS Package in my web server rather than Database Server. So anyone please give me some suggestion to implement this.

Also I wanted to know whether I should have a SQL Server instance in the server where I am deploying my SSIS package?

Its pretty urgent. Help please.

Thanks & Regards,

Prakash Srinivasan.

View 3 Replies View Related

SSIS Deployment

Oct 18, 2006

Hello,

I would like to know how to set up the SSIS package with the DATABASE, SERVER NAME and Connection String into variables, so that I can change these parameters of the deployement, on another name of server and database (and connection string).

Thanks a lot for your advices !
Marie-Thérèse

View 7 Replies View Related

SSIS Deployment

Oct 18, 2006

Hello,
What should I do to change the server name and the database when I deploy a package on another machine ?
SHould I change the value inside the configuration file (format XML) ?
Thanks in advance for your advices !

View 4 Replies View Related

SSIS Deployment

Oct 23, 2006

I ahve read previous posts on this but didnt get a clear answer for what I am trying to do.

I have couple of SSIS packages running in y dev environment, we will be moving this into production soon. These pachakes will be called from the webapp to run once the flat files are uploaded.

Production environment has separate web server and Sql server box. Now how do I deploy the packages and where...on webserver or sql server box?

workflow is user uploads a file which is saved on the webserver and then the package will start to upload the data to the SQL Server db. I have seen that while storing the location of the flat file in the configuration file for the package it stores the hard coded path of the flat file is there a way for to save the UNC path or how can I tell the SSIS config file to look for the file on the webserver?

During deployment if I want to save the SSIS packages on to the SQL server do I still have to install SSIS components on the webserver...? or if I choose to save it as file system on the Webserver what do I neeed to install on the webserver so that the packages can be executed from the web app?

Excuse my long post but wanted to give a clear overview of the problem...

Appreciate your help in advance...

Regards

View 4 Replies View Related

SSIS && Deployment

Jul 14, 2006

Several SSIS are deployed from a server A to a server B (Integration Services) with a SQL user and are stored in MSDB
- Most of the SSIS have their connection only after SSIS have been launched ; Delayvalidation is set to true.
- Application user the same SQL user from server A can launch the SSIS.
- But the same application on server C cannot launch the SSIS. The error is : OLE DB Connection error for the connection string
- Server A, B , C are Windows 2003 Server and belong to the same Windows Domain.
Can you suggest me some tips ?

View 1 Replies View Related

SSIS Deployment

Apr 16, 2008

Hi all,

I would like to deploy my SSIS project on the production server. As far as I know from the last deployment, I had to change configuration managers to data sources to the ones of the production server. I had to go through all packages and change it. What is the best way to do this? I.e. Can I do it through a configuration file?

Thanks.

View 1 Replies View Related

SSIS Deployment Methods

Oct 12, 2007

I have developed the SSIS project, but I have a problem with deployment. My users are statistic people and SSIS packges they use are cleaning the raw data for them. Since they would like to run this SSIS package by themselves whenever they want, I need some deployment method that is easy for them to run (they are really not IT oriented people). The problem I encountered is that there is no visual studio (integration service client) installed on there computer, but they are allowed to access several dbs and server on the net.

Can someone tell me what is the best solution for this type of deployment?

View 4 Replies View Related

SSIS Integration / Deployment

Apr 12, 2006

I'm very new to the use of SSIS in a real enterprise environment. I've used DTS in the simplistic method of import/export but little else. As myself and a few others new to the tool are working through some things two questions have come up.

1.) What is the best way to execute an SSIS package using Java?

2.) Is it possible to deploy an SSIS package to a server that does not have SQL Server installed? I've read a few things that suggest that embedding the SSIS runtime environment in an application is possible but definitely not a beginner type operation.

Any quick guidance you can provide would be greatly appreciated.

View 3 Replies View Related

SSIS Dependencies On SQL Deployment

Mar 8, 2007

Sorry to start a new thread, actually Darren answered my first question on SSIS dependencies but I have a clarification and somehow the software of this forum doesn't allow me to post again on my previous thread. (my posts disappears after some time).

My question is that if I choose to deploy the SSIS packages in SQL Server, then SSIS would have a dependency on SQL Database.

Do we know where the deployed packages are stored in SQL. This information is needed so that I can maintain and monitor the DB where the deployed packages are stored.

Also, do you think its a best practice to deploy the packages in SQL ( I think it will be good because then I can have consistent version of a package deployed on many machines... since I store my packages on one consistent DB rather than multiple file folders on each machine).

regards,
Abhishek.

View 1 Replies View Related

SSIS Deployment Question

Oct 27, 2005

Hi,

View 5 Replies View Related

SSIS Deployment - Redefined

Oct 31, 2007

1) Every package has to have its own configuration file? There's no configuration on a project level?
2) is there anything in particular I have to do with a configuration file before running a build? When I run deployed package it seems like it ignores my configuration file and takes the connection string of conn. manager i use in development.

View 10 Replies View Related

Enterprise Deployment Of SSIS

Jun 13, 2006

Hello, we are interested in upgrading our Data Warehouse environment to SQL Server 2005 to take advantage of SSIS. Our current data warehouse environment consists of 2 production servers with over 900 DTS packages between the 2 servers.

Are there any white papers out there detailing what type of deployment works well for an Enterprise wide use of SSIS? We're trying to determine if we should use SSIS on the same server hosting our databases, or separate SSIS onto its own dedicated box. If we went the dedicated route, what type of horsepower would we need on the SSIS box (procs, RAM, etc.)? Also, if we went the dedicated route, does it make sense to have 1 SSIS server that handles the data warehouse packages and the OLTP packages, or should that be separated into 2 SSIS servers having one server for each environment?

Thanks for any help you can provide on this subject!

Eric

View 1 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 Deployment Clarificaiton Needed.

May 26, 2006

I'm all mixed up on this one. Please comment on either of the following two remarks.



1. When I create a new SSIS package under BIDS I gather it is intended for development purposes. .I can test the package and run it but I need to"deploy" it (possibly to another server) to make it available for others to use.

2. Is "deploying" essentially copying my package (.ldtsx) to a new server or does it involve a lot more?

3. I read that I can create an SSIS package without actually needing to have sql 2005 installed on my box. Suppose I create a package that makes no reference to any databases. To *run* this package will I need sql2005 installed or can BIDS do this?

TIA,

barkingdog

View 3 Replies View Related

Custom SSIS Task Deployment

Oct 4, 2006

I've written several custom Control Flow and Data Flow components for SSIS. I'm trying to deploy a new Control Flow Task, however it will not show up in the "Choose Toolbox Items" window.

I have my dll's all in the right place. Because of other painful issues we have not used the GAC, and instead have put our DLL's that are referenced in the following directory: C:program filesMicrosoft SQL Server90DTSBinn. This has worked fine for other custom tasks, but not for this one.

The only things that are different about this transform are the following:

1. Not only does the task inherit from Task, it also implements two interfaces that I wrote.

2. One of the assembly references is actualy an executable instead of a dll. This is unusual, but I've done it with other .NET projects and not had any trouble.

I could move the code I need from the EXE out to a DLL. If somebody knows what could be causing this please respond?

View 4 Replies View Related

SSIS Deployment To SQL Server Problem

Oct 24, 2007

hello,
i got this error when i tried to build my project prior to deployment. S.O.S.
Error 1 System.ApplicationException: Could not copy file "D:Documents and SettingsMy DocumentsVisual Studio 2005ProjectsSSISSolutionSSISSolutionPackageConfig.dtsConfig" to the deployment utility output directory "D:Documents and SettingsMy DocumentsVisual Studio 2005ProjectsSSISSolutionSSISSolutioninDeployment". ---> System.IO.IOException: The file 'D:Documents and SettingsMy DocumentsVisual Studio 2005ProjectsSSISSolutionSSISSolutioninDeploymentPackageConfig.dtsConfig' already exists. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) --- End of inner exception stack trace --- at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CopyFiles(ICollection fileNames, String outputPath) at Microsoft.DataTransformationServices.Project.DataTransformationsProjectBuilder.CreateDeploymentUtility(IOutputWindow outputWindow)
0 0

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

SSIS Deployment And Removal Issues

Feb 20, 2007

I created a setup package and installed it on my SQL2005 server. I cant seem to find anywhere on the server where they are installed, but I can access them from the Job schedule tool, which work for me.

However, now I have to upgrade the deployed SSIS and I cant seem to install on top of an existing one (gave me no errors but after testing it i realized it is still running the old version.)

My questions are:

1) How can I find and delete these SSIS packages from the server?
2) How can I just upgrade for a new version of a SSIS package?

I need to be able to do both things as at some point I may want to just remove some packages.

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

Deployment Of SSIS With Config Files

Jul 12, 2007

I went through other threads and links on this subject. Still one thing which concerns me is the config files.

My current folder path is C:Karunakaranfolder1folder2

Under folder2 I have the following files

4 dtsx files
1 .database file
1 .dtproj file
1 .dtproj.user file
1 .sln file
1 .suo file

Config folder ( C:Karunakaranfolder1folder2Config)
common.dtsConfig
oracle.dtsConfig

Based on some of the threads, when I enabled package configuration, I changed the path from
C:Karunakaranfolder1folder2Configcommon.dtsconfig -> common.dtsconfig

Once I did this, when I open the project I get a dozen of warning similar to the one below

Warning loading <package1>.dtsx: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.

What am I doing wrong here? If I have to deploy this to another box, what should I do to ensure that nothing breaks once its copied / installed?

Thanks

View 21 Replies View Related

SSIS - Data Sources - Configure For Deployment?

Jan 26, 2006

I had posted this in the following pre-existing thread :

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=89737&SiteID=1

Also wanted to start a thread on this to see if I can get some suggestions. Any suggestions on how to do this are appreciated.

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

Books-Online quote:

>> In Integration Services, data sources are design-time objects that you use when you build packages in SSIS Designer.


This is indeed the case but why? I would like to see it changed or provide some way of including the data source in some kind of a "solution/project configuration", the same way one can create a "package configuration" right now.

If one can build a project, and create a deployment utility to deploy the entire project (all packages), it is incoceivable why one shouldn't be able to set configurations at a "project" level.

Right now I am having to create package configurations to configure my connection setting for dev/test/prod etc environments. But the trouble is, if I have 10 packages each involving 3 connections in my project, I have only 3 data sources in my project, but come deployment time, I'm having to create 10 package configurations, and set my ConnectionString (which is different for dev/test/prod etc) 30 times during deployment.

If there is a better way to do it, I would like to know. Otherwise, this is what I would like to see in the next SP.

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

thanks,

RV

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

SSIS Deployment Question About Conn Strings? Please Help.

Jan 23, 2007



Hi everyone:

I have a package(SSIS) that works fine on a local SQL Server. Once I deploy it to the server A, and change the connection strings, it throws the following error:

Error: The AcquireConnection method call to the connection manager "DatabaseName" failed with error code xxxxx.
Error: component "OLE DB Destination"(16) failed validation and returned error code xxxx.

Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client" Description: "Communication Link Failure"

Error: Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client" Description: "TCP Provider: An existing connection was forcibly closed by the remote host."

Error: Error: An OLE DB error has occurred. Error Code: 0x80040E4D. Al OLE DB record is available. Source: "Microsoft SQL Native Client" Description: "Login failed for user 'username'."

I have confirmed from my Network Engineer that this is not a Network issue. I can connect to the the target sql server from SQL Server A(where the package is running). The only thing that has changed is the connection string. In my package I connect to a local database on the server, and a remote SQL server. The connection to the local sql server works fine from the package. The remote SQL Server connection string is not working, I think. I also noticed that after I enter my password in the conn string, within the VS 2005, after building it, and deploying it on the server, I check back the conn string, and it is no longer there. I have read some posts about it, and I understand that SSIS hides it. What is the work around here? I have never used config files for SSIS, so I would need exact instructions to do that, if that is the way to go. Has someone else ever ran into this error? I have seen some posts on the forum with similar error, but they are not providing any solid answers. In my case, I need to know how to implement either a config file for conn strings, or how to deploy with conn strings which retains password. I can connect to a remote SQL Server from SERVER A utilizing SQL Management Studio, therefore any firewall/port issues are not relevant. I feel the issue is with conn strings, and I need some solid advise on how to implement them especially, where in my case, one of my connections is to a remote sql box, utilizing Sql server authenticaion(which involves use of password). Thanks.

Here is how my current connection string looks like and notice there is no attribute for password:

Data Source=192.1.1.1xxx;User ID=username;Initial Catalog=databasename;Provider=SQLNCLI.1;Persist Security Info=True;

View 13 Replies View Related

Error When Deploy SSIS With Deployment Wizard

Jul 17, 2006

I've get error when I deploy SSIS package with Deployment wizard like this



===================================

Could not save the package "C:Documents and SettingsaunMy DocumentsVisual Studio 2005ProjectsImportCommitteeImportCommitteeinDeploymentIMPORT_FS_DATA.dtsx" to SQL Server "(local)". (Package Installation Wizard)

===================================

The SaveToSQLServer method has encountered OLE DB error code 0x80040E21 (Invalid character value for cast specification). 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 0x80040E21 (Invalid character value for cast specification). 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)



I've ever pass deploy wizard with test program (a little line of code) but when I've deploy with my real code it's return error I've show above



Thanks for your help

Pipope

View 3 Replies View Related

Automating File Deployment Of SSIS Packages

Jul 10, 2007

Hi:



I am trying to utilize DTUtil command to automate deployment of SSIS Package from the Build Server to Dev Server. I am getting an invalid option error, when I try to run the following command:



dtutil /FILE C:Program FilesABCABC ABC CADETL PackagesLoad_Staging_FromWCF.dtsx /MOVE FILE;\serverAC$Program FilesABCABC ABC CADETL PackagesLoad_Staging_FromWCF.dtsx /QUIET



Currently I have a .CMD file, in which I have the above command, and I am trying to run the CMD file and it returns an error. Can someone help me the DTUtil switches. My goal is to move a DTSX file from Server A(Build Server) to Server B(Dev Server). Also is there a switch to specify the server name, if UNC path is not supported. Also I am using File System Deployment, and running the file as an Administrator. I have admin privs on both Build and Dev Server. Thanks and I appreciate some help on this.





View 3 Replies View Related







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