Post reply

How to open Package in Design mode in SQL 2008

  • October 29, 2009 at 9:37 am

    #216799

    Hello,

    I just want to know How to open Package in Design mode in SQL 2008?

    The reason I want to run the package in a design mode,

    Help much appreciated,

    Thanks,

    Dev

  • October 29, 2009 at 10:01 am

    #1072590

    Do you have the source for the package? Or just what was imported into the msdb in SQL server?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 29, 2009 at 10:03 am

    #1072591

    The imported ones please

  • October 29, 2009 at 10:18 am

    #1072611

    You will need to export them and use them in conjunction with the source code and solution file that goes with the package.

    Example Using SSIS Package:

    You would export the Package.dtsx file, locate the *.sln file for that package, open the sln file - then you can run the package in debug mode.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 29, 2009 at 10:20 am

    #1072613

    First thing First you say its 2008 and posted in 2005 Forum and also if I am not wrong you are talking about SSIS Packages, which should have been posted in SSIS.

    Any way, create a new SSIS Solution and include that Imported package in the Solution Explorer.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • October 29, 2009 at 10:22 am

    #1072615

    OK Thanks

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

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