sql server dts: Export/Import VIEW problem -- sql server dts

Export/Import VIEW problem

Stefan Nilsson
4/21/2004 12:49:57 AM

sql server dts:

I have a problem when expoing VIEWs from one table to
another (using the Export/Import Enterprise manager tool).
In the destination table they appear as tables ... not as
views.

Any fix for this?

I use SQL2000SP3 on IBM netfinity machines w. W2003.

Stefan Nilsson

Re: Export/Import VIEW problem

Allan Mitchell
4/21/2004 9:20:03 AM

Views are materialised as tables. This is by design. If you only want the
view definition then you will need to script it out.

--

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

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]