Re: Transform Data Task - properties gives error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Thomas Turn Jensen (anonymous_at_discussions.microsoft.com)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 07:20:40 -0800

Hi Allan,

I could kick myself so hard.. you are right I got the
error number wrong. How I managed to do it I don't know,
but I did.

Thanks for your input - your reply actually let med in
the right direction, and it turns out the oracle client
software which was needed for the source connection (to
an Oracle DB) was not installed! if only it had told me
that...

I had a person on site install the oracle client and
after tweaking a bit with that (don't ask me what he did -
 he knows Oracle - I don't), it is now working like a
charm.

And I must say this will definately not be the last time
I touch DTS - it's awesome.

Thanks again very much for your help!

>-----Original Message-----
>OK
>
>What are the datasources?
>
>0x40008005 do you mean 0x80004005?
>
>The latter is an Access Denied/I'm not there error.
>
>Does the package make use of DSNs, Non-Standard OLEDB
providers(Oracle ?)
>
>
>
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.allisonmitchell.com - Expert SQL Server Consultancy.
>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
>
>

Relevant Pages

  • RE: DTS scheduled job is failing on Windows 64 bit
    ... I have taken following steps to fix it ... This has to be done because SQL Server Agent Jobs which access DTS don't ... Oracle Client – ... After movement DTS packages are running fine when I tried to run it through ...
    (microsoft.public.sqlserver.connect)
  • Re: How to connect SQL Server to an Oracle database
    ... Install the Oracle client on the SQL Server box. ... Configure the client side (SQL Server box) tnsnames, Oracle ... >Server running in AD. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server tables to Oracle
    ... You can use DTS packages from within SQL Server. ... do is install the Oracle client libraries on the SQL Server box and define a ...
    (comp.databases.oracle.server)
  • generic resource
    ... Pardon if this is not the correct forum but I have a requirement to install the Oracle client on a 2-node MS cluster used exclusively for SQL Server 2000 clustered instances. ...
    (microsoft.public.sqlserver.clustering)
  • generic resource perhaps?
    ... Pardon if this is not the correct forum but I have a requirement to install the Oracle client on a 2-node MS cluster used exclusively for SQL Server 2000 clustered instances. ...
    (microsoft.public.sqlserver.clustering)