Re: I can attach in SQL Server, but can I in Oracle?
From: Ross McKay <rosko_at_zeta.NOT.THIS.BIT.org.au>
Date: Sat, 09 Aug 2003 13:02:41 +1000
Message-ID: <cpo8jvkqjbmbmpveplrlpjmjir9ugcc590_at_4ax.com>
Date: Sat, 09 Aug 2003 13:02:41 +1000
Message-ID: <cpo8jvkqjbmbmpveplrlpjmjir9ugcc590_at_4ax.com>
On Sat, 09 Aug 2003 01:57:12 GMT, "Ron Fluegge" <rmflugge_at_swbell.net> wrote:
>I looked at building a DTS package from SQL Server 2000 and was not
>comfortable with trying to get that implemented in a client's Oracle shop
I suggest that rather than build from SQL Server using the GUI build interface, build it from code. It's actually pretty easy, IMHO easier than trying to coordinate the GUI packages to efficiently do what you want them to do. Also, this way you can conditionally build the package.
To get this going, what you need to realise first is that DTS is just a bunch of COM objects, and does *not* require an instance of SQL Server to run (just a license held by the person running it...)
cheers,
Ross.
-- Ross McKay, WebAware Pty Ltd "Since when were you so generously inarticulate?" - Elvis CostelloReceived on Sat Aug 09 2003 - 05:02:41 CEST