Post reply

Can I initiate a database backup withing SSIS?

  • September 15, 2009 at 9:44 am

    #138866

    I have a request from the user to initiate a database backup withing SSIS before running the package. Is this possible and if so how?

  • September 15, 2009 at 9:48 am

    #1053899

    Nevermind I found it.

  • September 15, 2009 at 10:11 am

    #1053932

    The answer is yes, you can. Add a step to do this with a T-SQL command.

    Note that if you find an answer, it's good etiquette to post it.

  • September 15, 2009 at 11:36 am

    #1053996

    I am having job running SSIS package,which is having 4 steps as below

    1.Database Integrity -- success

    2.Clean Up History --success

    3.Update Statistics --- failed

    4.Reorganize Index--success

    -->update statistics got failed due to below error..

    Failed [Sad] -1073548784) Executing the query "UPDATE STATISTICS [dbo].[PDE_RFEQP_MVMNT_EVENT_DN] WITH FULLSCAN " failed with the following error: "A severe error occurred on the current command. The results, if any, should be discarded. A severe error occurred on the current command. The results, if any, should be discarded.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Can any one help me pls...

  • September 15, 2009 at 11:46 am

    #1054003

    Please start a new thread if you have a question. You might try running update statistics manually first to be sure it will run.

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

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