Post reply

Help with SSIS Package - Won't always execute.

  • July 21, 2009 at 6:12 am

    #212642

    Hello All.

    I have a fairly simple package that gives me trouble. I start with 2 execute sql tasks that never give me a problem and then to a data flow task. I have a connection to a DB2 database that inserts records (2-3 million) into a SQL 2005 table. That insert will not always run. WHat happens is i get a very quick flash of a DOS screen...disappears and then the package claims it is finished with the data flow box still yellow. i have let it sit for a while and nothing. No error message. The strange part is that sometimes it runs, most of the time it doesn't.

    Not sure if it's timing out or what.

    I believe we have SP2 installed.

    I have seen similar posts on the web with no solutions

    Thanks

    Peter

  • July 21, 2009 at 6:24 am

    #1027555

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic756507-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 21, 2009 at 6:36 am

    #1027563

    thanks for the help.

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

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