Post reply

SSIS package runs successfully, but no records imported

  • November 12, 2011 at 8:08 pm

    #146141

    I have a data flow task that imports records from textfile to a sql table.

    It shows green successful status and in the log it also says it writes to the destination table 118 records. But when I look at the sql table, no records are imported.

    What could be wrong?

  • November 14, 2011 at 1:57 am

    #1406980

    Stupid question, but did you connect to the correct server?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • November 14, 2011 at 9:58 am

    #1407364

    Yes, it is the correct server.

  • November 14, 2011 at 11:28 am

    #1407440

    You say it pushed 118 records. ok, are you sure of the table? How is the table set in the destination? Explicitly set? Variable? what?

    CEWII

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

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