Re: Cannot Open SQL Server Table in Access.ADP File.

uh what tables are you copying using this DTS package?

'all of them' are you including system tables?

how many tables; any that start with sys for example?

-Aaron



Greg wrote:
I performed this task it it failed. Got the following error messages:

- Validating (Error)
Messages
Error 0xc0202049: Data Flow Task: Failure inserting into the read-only
column "diagram_id".
(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow Task: Column metadata validation failed.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task: "component "Destination - sysdiagrams"
(31)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

Not quite sure what do to with these error messages. Thanks for the help
though.

Greg Setnes

"Peter Yang [MSFT]" wrote:

Hello Greg,

I understand that you'd like to script out database diagram. Based on my
research, I think we are not able to script out a database diagram in
script wizard. Database diagrams are stored in the "sysdiagrams" table of
each database. In this table the diagram is stored in a column with a
varbinary(max) datatype, which SQL Server translates the data in this
column to the diagram you see on screen.

However, you could use Import/Export wizard to migrate diagram between SQL
2005 databases:

1. Right click the new database->Task->Import Data
2. Select Source Server and database (old database)
3. Select Destination Server and database (new database)
4. Select "Copy data from one or more tables or views"
5. Select "databasename.dbo.sysdiagrams"
6. Click Finish to import the table.

If you have any comments or concerns on this, please feel free to let's
know. Thank you

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


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

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================




.

Relevant Pages

  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: Data Source error... help!?
    ... installed the SQL Server 2000 connectivity files from the SQL Server ... I just can't connect at all from the New Data Source wizard. ... SQL Server 2000 Standard database on another machine. ... Here is the connection string it's ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Data Source error... help!?
    ... installed the SQL Server 2000 connectivity files from the SQL Server ... I just can't connect at all from the New Data Source wizard. ... SQL Server 2000 Standard database on another machine. ... Here is the connection string it's ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Data Source error... help!?
    ... installed the SQL Server 2000 connectivity files from the SQL Server ... I just can't connect at all from the New Data Source wizard. ... SQL Server 2000 Standard database on another machine. ... Here is the connection string it's ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Table design exportation
    ... In order to launch the Database Diagram component, ... Launch Enterprise Manager from the Start> Programs> Microsoft SQL Server ...
    (microsoft.public.sqlserver.tools)