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? |