Post reply

BIDS open package in database

  • January 29, 2009 at 6:46 am

    #218112

    I saved a package in BIDS onto a server database. In BIDS, when I try to open the package, I get msdb does not exist. Another database does show up called "admin". I can open that one ok. I can schedule a job and see the package there. And yet, when I go into Management Studio I can see MSDB there.

  • January 29, 2009 at 8:41 am

    #934749

    Connect to SSIS (Integration Services) and not MSDB in your database server.

  • January 29, 2009 at 11:03 am

    #934911

    ok, in BIDS, how do I connect to SSIS?

  • January 29, 2009 at 11:19 am

    #934927

    Not in BIDS. In SQL Server Management Studio, click on connect and change from database service to integration services. If u just want to check if the package exists in msdb, select * from the sys.dts**packages etc tables in msdb database.

  • January 29, 2009 at 11:34 am

    #934941

    Sailor (1/29/2009)

    I saved a package in BIDS onto a server database. In BIDS, when I try to open the package, I get msdb does not exist. Another database does show up called "admin". I can open that one ok. I can schedule a job and see the package there. And yet, when I go into Management Studio I can see MSDB there.

    In BIDS, did you right-click on SSIS Packages and select "Add existing package"? All I can think is you put in the wrong server name when specifying where to retrieve the package from.

    Greg

  • January 29, 2009 at 12:32 pm

    #934989

    Greg Charles (1/29/2009)

    Sailor (1/29/2009)

    I saved a package in BIDS onto a server database. In BIDS, when I try to open the package, I get msdb does not exist. Another database does show up called "admin". I can open that one ok. I can schedule a job and see the package there. And yet, when I go into Management Studio I can see MSDB there.

    In BIDS, did you right-click on SSIS Packages and select "Add existing package"? All I can think is you put in the wrong server name when specifying where to retrieve the package from.

    ahhh, no I did not try to right click on SSIS packages! I was trying under File->Open->Analysis Services Database.

    I think that's it...(right mouse click on SSIS package which will load from sql server)...

  • January 29, 2009 at 12:40 pm

    #934994

    Right. You'd do what you were trying if you were developing an Analysis Services project, not an Integration Services project.

    Greg

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

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