April 3, 2007 at 9:41 am
I just started learning SQL Server 2005, I have created a new package in SQL Server but now donot know how to open it in design mode.
Can anybody assist me?
Data Sheet
April 3, 2007 at 10:30 am
How did you create the package? If you created it using the business intelligence development studio, then it's simply opening the project file, however, if you saved it after performing the process in management studio you will have to transform it from an MSDB to the filesystem before you can open it in the development studio.
Marvin
Marvin Dillard
Senior Consultant
Claraview Inc
April 3, 2007 at 11:21 am
Hi Marvin,
Thanks for the reply, Yes I saved it using Management studio(Import wizard). How can I transform from MSDB to filesystem?
Also it means we cannot save DTS Packages in MSDB? prefered way is to use filesystem? then we have to keep backup of that filesystem? is it not better to save DTS packages in database which backed up daily?
Data Sheet
April 3, 2007 at 12:09 pm
Data Sheet
here is one way to do it, I'm not sure if there are others,
Connect to an instance of Integration Services on the server the MSDB package is stored. Expand the stored packages node and right click on File System, choose Import Package and then complete the box that is popped up (server, package et al). After all is complete, click OK and the package is then saved as a file system package. You can then find the package in the program Files\microsoft SQL Server\90\DTS\pacakages directory.
Marvin
Marvin Dillard
Senior Consultant
Claraview Inc
April 4, 2007 at 5:53 am
You can get the full DTS Designer environment in SQL 2005. This allows you to create new DTS packages on SQL 2005, and keep them in MSDB.
Download the DTS Designer Components (part of the SQL 2005 Feature Pack) and install on both the SQL Server box and any required client machines. Also review KB 917406 in case you need to apply this fix.
Locate a package in SQLMS, then right-click on it to allow you to open it in Designer mode.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 5, 2007 at 12:57 pm
Data Sheet,
Did you create a DTS package or an SSIS package? If you're just getting started in SQL 2005, I suggest you read up on SSIS and how it's different from DTS.
Good Luck,
Greg
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply