Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2006-07-26 : 11:47:07
|
| Hi friendsI am trying to save a package in metadata servicesIs there any reason why it cannot show the option of Metadata services but show the other options like sql server , Structure storage file and Visual BasicThanksVic |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-26 : 12:03:24
|
| Foundhttp://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/If you use Meta Data Services, previously called the Repository in SQL Server 7.0, you may encounter some problems. Meta Data Services is not supported by SSIS, which is not surprising considering that SQL Server 2000 Service Pack 3 removed Meta Data Services as a storage location. This is not a significant change, however, since the existing DTS object model and the DTSRUN command-line tool continue to support Meta Data Services.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-07-26 : 12:09:54
|
| thanks nr...The information is usefulVic |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-26 : 12:12:47
|
| Alsohttp://www.databasejournal.com/features/mssql/article.php/3404791In order to save a package to Meta Data Services, you need to first enable this option. This is done from the Package Properties dialog box, displayed after selecting the Properties item from the context sensitive menu of the Data Transformation Services node in SQL Server Enterprise Manager. From there, you need to mark the checkbox labeled "Enable Save To Meta Data Services". This will activate another option in the Location listbox when saving a DTS package.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Meta Data Services