Error when I try to copy components and tasks

Hi everyone,

Everything's fine or I think so but when I try to copy/cut components to another SSIS of to own.

I get this error:

Error al copiar objetos. El Dise?ador SSIS no pudo serializar los objetos de tiempo de ejecución de SSIS.

No se pudo copiar el objeto 'Tarea Secuencia de comandos ActiveX' al Portapapeles.

(Microsoft.DataTransformationServices.Design)

Tranlasted into English (more or less):

Error copying objetcts. SSIS designer was not able to serialize run-time SSIS objects

ActiveX Script task was not copied to clipboard

NOTE: this behaviour doesn't happen in the own server only from client (xp pros sp2). Nothing has been changed I don't know if install again or not.

Any help will be welcomed.

I thought it maybe something to do with the ActiveX Script Task since it is legacy, but that is rubbish. Not much help, but it seems to be something not right with your local installation.|||

Thanks Darren.

I suppose that for Integration Services' Microsoft developers keep up old COM schemes is a hell in a certain way.

I try to imagine Sql25k without any dependencies...

By the moment, I'll follow working via TS.

|||

Darren,

How odd! It happens with any component not only with VbScript task.

?

Error when creating script to copy Stored Procedures

Our DB has around 30 SProcs - I need to move them into a script, so that it can be easily added to another server. The way I'm creating the script is to highlight all the SProcs, then copy - in my notepad screen, I paste, which gives me one script, which includes all the individual creation scripts for the Sprocs.

However, I'm getting an error when I create the script -

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'SP_MySproc'. The stored procedure will still be created.

So - what's a good, and/or easy way to structure the script, so that I can easily find WHERE to put Which SProc Script, in the list?

Hey,

You could follow those steps:

Right click Database in Sql Server Management Studio -> Tasks->Generate Scripts->choose databse ->...->check Stored Procedure->next...

|||

That still gives me the same error - I guess what I'm asking is:

how can I figure out what order the Stored Procedures need to be scripted, so this error doesn't happen?

|||

Hi

The generate script option only guarantees that the script can pass compile and the order is determined by design.

If you don't mind you could execute script twice and error should go away in the second time.

Hope this helps.

|||

Hi,

If you are sure that all procedures you need are in your script do not worry about the errors, procedures will be created and will work. The only problem will be if you call procedures from another table which are not scripted or if you script your procedures into another database (with different name) and you used call like exec [Sourcedatabase].[dbo].[Procedurename] so it is possible in this case that your procedures will not work if database [Sourcedatabase] is not visible on your server from inside your destination database so check your script for "long" calls.

If you would like to have procedures in correct order you can write TSQL script which will script procedures for you in correct order, I hear about application which can do it for you and you can do it by hands by ordering your procedures in the script the way that procedure is defined before is called by another procedure.

Thanks

JPazgier

Error using Copy Database Wizard in SSMS - SQL 2000 to SQL 2005

I have successfully used the Copy Database wizard in the past to copy from
SQL 2000 to SQL 2005 - both on my machine.
But now I always get an error at the Finsih step saying: "No description
found"
This occurs on the 3rd step of the process - Create Package.
I have tried changing all the options but always get the same error.
Les
lmcphee (lmcphee@.discussions.microsoft.com) writes:
> I have successfully used the Copy Database wizard in the past to copy from
> SQL 2000 to SQL 2005 - both on my machine.
> But now I always get an error at the Finsih step saying: "No description
> found"
> This occurs on the 3rd step of the process - Create Package.
> I have tried changing all the options but always get the same error.
Have you looked in the event log, which is where CDW logs by default.
(And it logs on the receiving server, not necessarily the one you
initiated the process from.) You can also redirect logging to a text
file.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error trying to copy stored procedures from one db to another

Hello,

The export menu in DTS is a bit confusing for me. I have some stored procedures in one SQL Server and want to copy them to another. The username is the same for both SQL Servers. When I try copying the stored procedure with defaul settings, I get a progress bar (24 percent ccompleted, 62 percent completed...), then when its done it says "failed to copy objects from sql server to sql server". When I double click the error for details it says "User or role '[username]' already exists in the current database". Then I try again, unchecking "use default options" for my export. I go in to alter the options, uncheck "copy database users and database groups" (I've also tried unchecking "copy object-level permissions"), run it, get progress bar (like above), and then get another error that says "There is no such user or group '[username]'".

My user name is correct, I am able to access both Sql Servers with this username, and I should have all of the appropriate permissions.

I think maybe there is a checkbox I'm not unchecking or something stupid like that.

Thanks in advance for any feedback.Wild guess here: the user who owns the sp is not dbo ?|||Wild guess here: the user who owns the sp is not dbo ?

Sorry, your msg is a bit cryptic for me. What are "sp" and "dbo"? My guess on the latter is "database owner". I will check with the administrator to find out if I can get a username with more privileges. It is a shared Sql Server with a web hosting company and there are dozens of databases that I can see in there, but do not have access to, so users and permissions are a little hairy, i'm sure.

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destination
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destination
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:
> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiting
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> > New to SQL Server, have never backed up a database before, in any DB
> > system.
> > I am following a set of instructions that spell out how to copy a source
> > db
> > and then copy it to a target db. Steps:
> > 1) log onto server
> > 2) start SQLServer Enterprise Manager
> > 3) select source db and then Tools->Backup Database
> > Here's where my questions lie - The correct db shows, I have Back-up
> > Database-Complete selected, and Backup to disk. There is one destination
> > identified from an earlier backup. I tried creating a new destination,
> > but
> > when I click OK, I get the error "The volume on device {my new destination
> > name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> > be
> > used to form a new media set"
> >
> > I don't see an option for BACKUP WITH FORMAT.
> >
> > I thought of trying to use the existing destination, but I'm not sure
> > whether to append or overwrite it. I am trying to get a full copy to put
> > into a test db.
> >
> > Help!
> >
>
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destinat
ion
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destin
ation
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:

> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiti
ng
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
>
>

Error trying to backup a database

New to SQL Server, have never backed up a database before, in any DB system.
I am following a set of instructions that spell out how to copy a source db
and then copy it to a target db. Steps:
1) log onto server
2) start SQLServer Enterprise Manager
3) select source db and then Tools->Backup Database
Here's where my questions lie - The correct db shows, I have Back-up
Database-Complete selected, and Backup to disk. There is one destination
identified from an earlier backup. I tried creating a new destination, but
when I click OK, I get the error "The volume on device {my new destination
name} is not part of a multiple family media set. BACKUP WITH FORMAT can be
used to form a new media set"
I don't see an option for BACKUP WITH FORMAT.
I thought of trying to use the existing destination, but I'm not sure
whether to append or overwrite it. I am trying to get a full copy to put
into a test db.
Help!
Hi,
Best recommendation is to Overwrite the media after taking a copy of exiting
file. If you append the file it will be tough while restoring.
See the BACKUP DATABASE and BACKUP LOG command in books online.
Thanks
hari
SQL Server MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
> New to SQL Server, have never backed up a database before, in any DB
> system.
> I am following a set of instructions that spell out how to copy a source
> db
> and then copy it to a target db. Steps:
> 1) log onto server
> 2) start SQLServer Enterprise Manager
> 3) select source db and then Tools->Backup Database
> Here's where my questions lie - The correct db shows, I have Back-up
> Database-Complete selected, and Backup to disk. There is one destination
> identified from an earlier backup. I tried creating a new destination,
> but
> when I click OK, I get the error "The volume on device {my new destination
> name} is not part of a multiple family media set. BACKUP WITH FORMAT can
> be
> used to form a new media set"
> I don't see an option for BACKUP WITH FORMAT.
> I thought of trying to use the existing destination, but I'm not sure
> whether to append or overwrite it. I am trying to get a full copy to put
> into a test db.
> Help!
>
|||Thanks, Hari
Um, where are the online books located?
Joe
"Hari Prasad" wrote:

> Hi,
> Best recommendation is to Overwrite the media after taking a copy of exiting
> file. If you append the file it will be tough while restoring.
> See the BACKUP DATABASE and BACKUP LOG command in books online.
> Thanks
> hari
> SQL Server MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:DFB464EC-CF3A-4C98-B9A9-E5711BF13EF5@.microsoft.com...
>
>

Error saving package to msdb (IA64 - April CTP)

When attempting to save a copy of my .dtsx package (from BI Dev Studio), I get the following error. Any one have any ideas? - note: This is an IA64 machine running W2k3 Server (SP1). If I select * from msdb.dbo.sysdtspackages90 I get no rows.

Thanks!
=============================================

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). The SQL statement issued has failed.
(Microsoft Visual Studio)

-
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword)
at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
at Microsoft.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

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

The ExistsOnSQLServer method has encountered OLE DB error code 0x80004005 ([DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.). The SQL statement issued has failed.

-
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.ExistsOnSQLServer(String bstrPackagePath, String bstrServerName, String bstrServerUserName, String bstrServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.ExistsOnSqlServer(String packagePath, String serverName, String serverUserName, String serverPassword)

Additional Info: I've been checking the public newsgroups and this error appears with SQL2000, too. Most proposed solutions relate to certificates being installed. I've checked the various places (xyz\certificates\personal) where the problem certificates might be and have found none, so uninstalling these certificates is not a solution.

Any other ideas? Any would be appreciated!

Thanks!|||I just blogged about this:
http://sqljunkies.com/WebLog/knight_reign/archive/2005/06/09/15772.aspx
Basically, with earlier CTP releases you have two options, supply a self signed cert to the server or upgrade to the June CTP.
Thanks,
K