dbTalk Databases Forums  

Copying functions with views bug in DTS

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


Discuss Copying functions with views bug in DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
neilx
 
Posts: n/a

Default Copying functions with views bug in DTS - 11-04-2006 , 10:12 AM






Using DTS in SQL Server 2000 SP4 I get the following bug:

Copy all objects - including dependent objects - copies functions
before views whether they depend on any views or not. This means the
DTS package crashes as it is unable to verify the function's
dependencies.

At the moment, I have to use 2 copy objects tasks and do these
functions in the second task.

I see from this newsgroup that this bug was reported 5 years ago. Does
this mean no-one else gets this problem, or do people just give up on
DTS (my guess) when it gets hard to do what should be easy (copy all
objects).

Conversely, am I doing something silly by creating functions that use
views?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.