Post reply

SSIS package to create backup of Procs and Functions

  • April 9, 2014 at 8:40 am

    #284461

    Hi all,

    i want to create SSIS package to create backup of Procs and Functions .

    Please guide me.

    Thanks.

  • April 9, 2014 at 10:16 am

    #1704594

    Why do you want to do that using SSIS ? When you say backup Procs and Functions, what do you mean exactly ?

    --

    SQLBuddy

  • April 11, 2014 at 7:35 am

    #1705282

    BACKUP DATABASE xxx

  • April 11, 2014 at 9:43 am

    #1705381

    Easiest and reliable way is to Generate scripts and save to a single sql file. one other way for ssis is use a Execute SQL task and write a query to pull all the data and save it to a file. To automate a process for backing up the whole database I would go with SSIS, but not this one I believe.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

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

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