Transfer Object: Views

#1

Hello,

I am trying to transfer views using SSIS: transfer sql objects. Every time
I do, I get the error that the table already exist. All I am trying to do
is transfer the view itself, not the data. Can anyone tell me what the
parameters should be for this?

DropObjectFirst: False (views are already dropped)
IncludeExtendedProperties
CopyData
CopySchema
UseCollation

Any help with this would be appreciated.
--
Thanks in advance,

sck10

#2

Hello,

Based on my test, I was not able to reproduce the issue.

1. Created a test table and testview based on the table

2. Copied the test table to the destination

3. Copied the view by using the following option

DropObjectFirst: False (views are already dropped)
IncludeExtendedProperties
CopyData
CopySchema
UseCollation

Best Regards,

Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

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

Quote:

From: "sck10" <sck10 (AT) online (DOT) nospam
Subject: Transfer Object: Views
Date: Thu, 1 Jun 2006 18:06:16 -0500
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
Message-ID: <uq4I9$chGHA.896 (AT) TK2MSFTNGP02 (DOT) phx.gbl
Newsgroups: microsoft.public.sqlserver.dts
NNTP-Posting-Host: 15.203.185.135.in-addr.arpa 135.185.203.15
Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFT NGP02.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:66259
X-Tomcat-NG: microsoft.public.sqlserver.dts

Hello,

I am trying to transfer views using SSIS: transfer sql objects. Every
time
I do, I get the error that the table already exist. All I am trying to
do
is transfer the view itself, not the data. Can anyone tell me what the
parameters should be for this?

DropObjectFirst: False (views are already dropped)
IncludeExtendedProperties
CopyData
CopySchema
UseCollation

Any help with this would be appreciated.
--
Thanks in advance,

sck10

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transfer Object: Views

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Transfer Object: Views - 06-01-2006 , 06:06 PM

RE: Transfer Object: Views - 06-02-2006 , 01:14 AM