I'm having problems getting anything to transfer from a remote SQL 2000
database to a local SQL 2005 database.

I have created a new SSIS project with a single Transfer Objects Task,
created a couple of SMO connections. Then set the properties to transfer all
tables etc (but no data)

When I execute the package is runs without any errors but nothing is
transfered.

Any ideas please ?


--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

I'm having problems getting anything to transfer from a remote SQL 2000
database to a local SQL 2005 database.

I have created a new SSIS project with a single Transfer Objects Task,
created a couple of SMO connections. Then set the properties to transfer all
tables etc (but no data)

When I execute the package is runs without any errors but nothing is
transfered.

Any ideas please ?


--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

Have you made sure that CopySchema = true?

Allan

"Michael Tissington" <mtissington (AT) newsgroups (DOT) nospam> wrote

Yes, CopySchema is true - but I thought this was only valid when copying
FROM a SQL 2005.

--

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Are you not thinking of the CopyAllSchemas and CopySchemaList
collections?

"Michael Tissington" <mtissington (AT) newsgroups (DOT) nospam> wrote

OK, Look like I might be getting somewere now ...

Now, after transfering all the objects I'm getting the following error

[Transfer SQL Server Objects Task] Error: Execution failed with the
following error: "ERROR : errorCode=0
description='FK_SQLViewUserReminders_SQLViewRequir edProperties' is not a
constraint. helpFile= helpContext=0
idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}".

Any ideas what might cause this ?

--
Michael Tissington
http://www.oaklodge.com
http://www.tabtag.com

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Where and how do you set CopyAllSchemas and CopySchemaList? I'm creating a
SSIS package and dont see any such option.


--
moondaddy (AT) nospam (DOT) nospam
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

In the Destination Copy Options section you should see an expandable
list of "Objects To Copy" if you set CopyAllObjects to false

"moondaddy" <moondaddy (AT) nospam (DOT) nospam> wrote