.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Transfered ssis of type maintenance plan connect to wrong server

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
I transfered a maintenance plan using the method to transfer ssis with sql server management studio.

The sql task contained in my maintenance plan are set to use the "local server connection".  Somehow, when I run the maintenance plan on the target server, the sql task get executed on the source server from which I imported the maintenance plan.

In other words:
I transfer a maintenance plan from server A to server B.
The maintenance plan is set to use local server connection.
Running the maintenance plan on server B affects the server A instead of the server B.

Is there a way to refresh or repair the "local server connection" so that it actually connect to the current server instead of the one the ssis was imported from.

Here are some references on the method I used.



View Complete Post

More Related Resource Links

SQL Server Maintenance Plan - Update Statistics fails if schema contains special chars


We have a database schema with a period in it's name.  This is valid as per http://msdn.microsoft.com/en-us/library/aa224033(SQL.80).aspx. When we create a maintenance plan to update statistics it will succeed if the object property is set to 'Tables and Views'. If this is set to 'Table' it will fail.

Steps to Reproduce

  • Create a new schema in a user database with a period in it's name, ie
    CREATE SCHEMA [Windows.EventLog] AUTHORIZATION [dbo]
  • Create a table with owner using schema created in #1, ie
    CREATE TABLE [Windows.EventLog].[Computer](
    	[ComputerId] [smallint] IDENTITY(1,1) NOT NULL,
    	[ComputerName] [varchar](255) NOT NULL,
    ) ON [PRIMARY]
  • Create a new maintenance plan, drag 'Update Statistics Task' to designer surface, edit properites, choose the user database, View T-SQL and test execution: it will work
  • Edit maintenance plan and modify 'Update Statistics Task', change Object to Table, change selection to all, execute task and it will fail. Also, if you now try to click 'View T-SQL' or change it back to 'Tables and Views', a error dialog with title 'Microsoft.SqlServer.MaintenancePlanTasksUI' shows will message 'Object

SQL Server 2008: Error in Creating Maintenance Plan



We are trying to create and edit a Backup Script in Maintenance plans.  It is throwing the following error. Please help.




See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IO.FileNotFoundException: Could not load file or assembly 'msddsp, Version=,

Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the

file specified.
File name: 'msddsp, Version=, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'
   at Microsoft.DataTransformationServices.Design.DtrControlFlowDiagram.OnComponentChanged(Object

sender, ComponentChangedEventArgs chevent)
   at System.ComponentModel.Design.ComponentChangedEventHandler.Invoke(Object sender,

ComponentChangedEventArgs e)


ntChanged(Object component, MemberDescriptor member, Object oldValue, Object newValue)


ed(Object component, MemberDescriptor member, Obje

sql server maintenance plan schedule time and execution time difference


Hi All,

One of my customer db there is one maintenance plan(full backup / Transaction log backup  ) schedule time for the full backup is 11:00:00 PM daily and for transaction log backup 12.30 pm Sunday to Friday ,I checked the job created by maintenance plan there also schedule time is same but when i check the history of the job it shows it happened at 7:00:00 pm every day. why there is time difference ?

Product version is 8.00.2055(SP4)

i checked the MSDB.dbo.sysjobschedules table and the next_run_date is not updated properly,it is showing yesterday 11:00:00 pm


please help me to resolve this issue




Backup Maintenance Plan Failure SQL Server 2005

Hi All,
I have three maintenance Plans Full, Differential and Transaction Log backup. Full and Transaction Log backup plans are working fine. In the all the maintenance plans I am taking backup of almost 60 databases.

The problem is with the differential backup plan. The backup plan is keep failing with the following errors:

FailedSad-1073548784) Executing the query "declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'MY_Database' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'My_Database' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''Giants_Security_4'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = N'E:\\MSSQL.1\\MSSQL\\Backup\\MY_Database\\MY_database_backup_200808240500.DIFF.BAK' WITH  FILE =

SQL Server 2008 Maintenance plan will not delete bak and trn files


I have a sql 2008 maintenance plan to backup databases and to delete old bak files.  The db backup works but the delete does not.  I do not get any error messages, all steps marked successful.  So, I copied the sql statement EXECUTE master.dbo.xp_delete_file 0,N'Z:\SQL BACKUPS\',N'bak',N'2010-11-14T12:43:35',1 and tried to execute in a query window.  I have a successful completion message, BUT the files are not deleted.  I have ensured that the extension is bak and the folder is correct and the account has sysadmin on the server and is a sql sa.  I have tried many options and no success.  

We are version   Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM).

Any help would be appreciated.  Thanks!

SQL Server 2008 R2 Missing Maintenance Plan Wizard

I do not see the "Maintenace Plan" option under the "Management" folder in SQL Server Mgt Studio

SQL Server Maintenance Plan

I have SQL Server Enterprise edition installed on windows server 2003, the problem is that the maintenace plan installed more than one time, after that I deleted all the maintenace scheduals from Management>Database Maintenance Plans

then I made one maitenance plan; the problem is that the deleted plans is still working and on of them produce a backup file with 3 GB size.
I checked the Management>Database Maintenance Plans but there was only one plan and it is working but I need to stop the other backups plans without the need to reinstall the SQL Server.

How can I copy a SSIS package from one server to another server and maintain the same OLE DB Connect


I have an SSIS package that has 10 data flow tasks that was created in Visual Studio 2005.

Each one has a different OLE DB Source but the same OLE DB Destination table.

I am moving from one 2005 server (A) DB to 2008 server (B) DB.  The DB has the same name. The 3 connections used for the 10 different OLE DB Source will be on server (B). The 1 connection used for the 10 different OLE DB Destination will be on server (B). The same OLE DB Destination table is also on server(B). 

When I convert this package to Visual Studio 2008, I lose my connections and have to change each one to the connections on server (B).

Is there a way to change the OLE DB Connection manager 1 time, without having to change it 10 times for the OLE DB Source?

Is there a way to change the OLE DB Connection manager for the OLE DB Destination 1 time, without having to change it 10 times for the OLE DB Destination table.

Thanks for your help.


Types in Yukon: Managed UDTs Let You Extend the SQL Server Type System


The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precisely control the kind of data your type accepts, resulting in better data management. This article explores UDTs in "Yukon" and covers their design and implementation.

Peter W. DeBetta

MSDN Magazine February 2004

need help about "Unable to connect to remote server." using HttpWebRequest


Hello friends 
I am creating an application where I want to store an html page from one of my websites into another web site. 
For the same purpose I am taking the url of the html pages 
for example if I want to copy this page "http://mydomain.com/html/page1.html" then i take this url from a text box which user enters.

Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

How to connect to local instance of SQL Server 2008 Management Studio Express ?


I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Is this same as SQL server Reporting Service or else what can we say for these type of report genera

Hi      In my windows application I am generating reports using this steps          1) Creates a stored procedure in the sql server for the required report output          2) In the .Net application add new Item adds a DataSet1.xsd binds the stored procedure to the DataSet1           3) Adds a Report1.rdlc to the application and places the requred fields in the Report1.rdlc          4) Adds a ReportViewer control to a form and binds the Report1.rdlc to the ReportViewer contol and shows the report Is this same as SQL server Reporting Service or else what can we say for these type of report generation 

How to make SSIS Package Fail when something goes wrong

Hello, Is there any way I can make the package (SSIS 2005) fail when something happen? Like: if some value become zero I will to make the package fail from with in the SSIS, so that the AgentJOB  that started this package will know? Thanks, Prabhat Nath

Export Maintenance Plan in SSMS

Where are the subplan schedules when I exported /imported a Maintenance Plan in SSMS ? How can I ensure that they are exported with ?

Maintenance plan to rebuild Full-text index ? (SQL 2005)

Is it possible, through the GUI Wizard, to create a Maintenance plan that rebuilds (rather than reorganise/optimise) a Full text index in 2005 ? The full text index is based on one table only - so would using the "Rebuild index task" in the Wizard do the trick ? I wouldn't mind if the other indexes on the table were rebuilt too, but main concern in the Full text Index. If not - then I guess it would be a scheduled job which does a ALTER FULLTEXT CATALOG catalog_name REBUILD, but I thought it would be nice to keep it within the - Management - Maintenance plans - section of SQL Management Studio. Also - should this be preceeded with a transaction log backup ? Had some issues rebuilding them last night - seemed a Log backup was needed.

sqlcmd, cannot connect to server

I have SQL Server installed on a machine called SQLDEV. I log on to that machine and I run the command sqlcmd -s SQLDEV -Q "select * from <db>.<schema>.<some_table> -E This command works and returns a result set.   Next, I go to a different machine. On that machine I can use SQL Mgmt Studio to log on to SQLDEV using window authentication. However, if I run the same command as above, I get some kind of a connection error. The error says, ".... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections .....   Any suggestions/ideas why I am getting this error?
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend