RE: SSIS (SQL Svr 2005) - Oracle Password Always Null

Hi Robert,

Which task you are using to copy the table from Oracle to SQL Server?

If you have a DTS package in the SQL Server 2000, you could refer the
articles below to migrate the DTS package directly to see whether Oracle
will pass the Password this time.

How to: Upgrade from Data Transformation Services to Integration Services
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/301cd966-3c69-4dbe-8a41-
36a0b695f9ea.htm

Upgrading or Migrating Data Transformation Services
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/c6294e8e-96b6-4eab-8329-
bc811be0ead6.htm#upgradeISfromEarlierVersion

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: Conditional data copy SQL Server to Oracle
    ... I need to transfer records from a SQL Server table to an 'equivalent' ... The DTS package itself can be set up to do the SQL Server -> Oracle ... Some minimal ActivX code seems ...
    (comp.databases.ms-sqlserver)
  • Package fails when schedule from Oracle DB
    ... I have a small DTS package that try to get data from Oracle to SQL server. ... How could I grant access permission to Oracle DB from SQL server? ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS calling Oracle procedure
    ... Can someone let me know if there's a way of calling Oracle's procedure within a SQL Server DTS package please. ... The reason for this is that I need to execute the Oracle procedure to extract data from Oracle tables, then manipulate the data and dump the data into a temporary table which then get exported to SQL Server via DTS package. ...
    (microsoft.public.sqlserver.dts)
  • Re: Querying Oracle...
    ... Yes you need the Oracle bits on the PC/Server that runs the DTS package ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Limit saving DTS package to SQL Server
    ... package under Data Transformation Services in the EM). ... I wonder can I limit which login has the right to save DTS package? ... other ordinary logins. ... Can this be done in SQL Server? ...
    (comp.databases.ms-sqlserver)
Loading