Post reply

SSIS - runs with not errors but does nothing

  • June 12, 2008 at 6:28 am

    #186684

    Greeting SQL experts,

    I have a ssis package that selects data from tables in a MySQL database and inserts the data into tables withing a SQL server 2005 database. For some reason, the packages no longer work. The catch is that no errors are reported, and the scripts run to completion. Can someone suggest a way to troubleshoot this?

    Thanks in advance.

  • June 12, 2008 at 7:36 am

    #827847

    Just try with a "data viewer" at the pipe line after the fetch transformation in the task. If you had already tried this.... i am sorry to waste your time.

  • June 12, 2008 at 10:02 am

    #827971

    Enable package logging. This will allow you to see where in your task the data is "disappearing" to

    ~PD

  • June 12, 2008 at 2:51 pm

    #828135

    Right you are.

    The MySQL replication had gone down several days ago, so while I was querying the MySQL database as admin (which was up-to-date), the SSIS and SQL Server are restricted to read-only rights so were querying the replicated server, which contained empty tables.

    Thanks for the replies.

    AK

Viewing 4 posts - 1 through 3 (of 3 total)

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