SSIS Newbie

  • Hi All

    I am very new to SSIS and dealing with packages

    Please help me with something.

    When a package is created, is it always created in BIDS?

    When you save the package, do you choose if you want it saved on the file system or in SQL Server MSDB

    I'm confused about this process of creating, saving and accessing packages

    Thanks

  • SQLSACT (9/4/2012)


    Hi All

    I am very new to SSIS and dealing with packages

    Please help me with something.

    When a package is created, is it always created in BIDS?

    When you save the package, do you choose if you want it saved on the file system or in SQL Server MSDB

    I'm confused about this process of creating, saving and accessing packages

    Thanks

    You can use wizard also but there you will not have the flexibilty to configure it as per your need.Wizard can be used e.g. simple import export functionality.

    For more information about deployment and other SSIS realted contents please refer below url.

    http://msdn.microsoft.com/en-us/library/ms141026(v=sql.105)

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

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

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