Post reply

Moving data from ORacle to ORacle in SSIS Issue

  • April 18, 2008 at 2:43 am

    #128622

    Hi

    WE are moving data from one oracle table into other oracle table for learning SSIS .

    We have Created the Soruce and destination conenction using OLE db and it worked fine in the designer. We then add tha package in the SQL Server agent job. when we run the job it fails and not displaying the error message properlt , it just display check the history, in history nothing much is there

    Can anyone help how to slove this issue??

    Thanks in Advancd

  • April 18, 2008 at 7:04 am

    #804313

    Turn on logging in your package to capture errors. If you just right-click in the background of the control flow you will find the logging options.

    The SQL Agent will be running the package locally on the SQL server and the designer runs the package on whatever machine is actually being used for development. My first guess would be that you do not have the oracle client installed and properly configured on the SQL server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply