Post reply

Running SSIS Package with objects which don't exist during Validation

  • February 17, 2008 at 2:40 am

    #120089

    Hello,

    I work on migration from DTS to SSIS. In one package there are two tables which are created during package execution. SQL Server unfortunately vaidate package before execution and doesn't let me run it. I solved problem in Gui by setting option DelayValidation to True.

    Now I want to schedule this and have the same problem. I created job but I need to somehow pass this DelayValiudation=True to dtsexec command. Any ideas?

    MCP ID# 1115468 Ceritified Since 1998
    MCP, MCSE, MCP+I, MCSE+I, MCSA,
    MCDBA SQL7.0 SQL 2000, MCTS SQL 2005

  • February 20, 2008 at 10:35 am

    #780305

    I am assuming that when you say you fixed the issue in the GUI, you meant that you set the package property DelayValidation to true. If you saved and deployed the updated package, this value should still be set when you schedule the package to run using the dtexec commandline utility.

    😎

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

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