Post reply

DTS Package Rollback

  • August 7, 2006 at 1:18 am

    #114503

    Can anybody make me understand why the following is happening?

    I had created a customized DTS package, which reads data from a txt file and throws into the database and creates a log file for SUCCESS and FAIL and a GENERAL LOG for BOTH. But i doesn't come to know the reason for onething is that When a rollback is happend it creates/generates a SUCCESS LOG But when i check into the database no data is transferred.

    Please somebody help me on this topic.

  • August 9, 2006 at 11:39 am

    #654149

    Unfortunately, I can't see your package from here. Can you describe how it is set up a little better?Perhaps even include a screen shot of the package in DTS Designer.

     

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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