{"id":231,"date":"2011-05-31T15:27:21","date_gmt":"2011-05-31T15:27:21","guid":{"rendered":"http:\/\/eldar.pro\/?p=231"},"modified":"2019-07-18T20:16:06","modified_gmt":"2019-07-18T20:16:06","slug":"sql-server-2000-dts-in-ssms-2008-r2","status":"publish","type":"post","link":"https:\/\/eldar.pro\/?p=231","title":{"rendered":"SQL Server 2000 DTS in SSMS 2008 R2"},"content":{"rendered":"<p>Known bug when trying to edit DTS packages:<\/p>\n<p><a href=\"\/\/eldar.pro\/wp-content\/uploads\/2012\/10\/DTS2000.png\"><img loading=\"lazy\" decoding=\"async\" src=\"\/\/eldar.pro\/wp-content\/uploads\/2012\/10\/DTS2000.png\" alt=\"\" title=\"DTS2000\" width=\"611\" height=\"163\" class=\"aligncenter size-full wp-image-225\"\/><\/a><\/p>\n<p>described <a href=\"\/\/msdn.microsoft.com\/en-us\/library\/ms143755(v=sql.105).aspx\">here<\/a>, but the two links in the article &#8211; <a href=\"\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=3522\">Microsoft SQL Server 2008 Feature Pack page<\/a> and <a href=\"\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=11988\">Feature Pack for Microsoft SQL Server 2005 page<\/a>.<\/p>\n<p>Microsoft SQL Server 2005 Backward Compatibility Components available on both links, but only on the second one it will work with 2008R2 (Despite the fact that the date of Feature Pack release is earlier).<br \/>\nIn addition, <a href=\"\/\/msdn.microsoft.com\/en-us\/library\/ms143755%28v=sql.100%29.aspx\">here<\/a>, in the first comment are correct pathes to copy *. dll and *. rll files.<br \/>\nIn SSMS 2012 DTS package management <a href=\"\/\/social.msdn.microsoft.com\/Forums\/en-US\/sqlservermigration\/thread\/95fc49ec-a167-4adb-8c6a-6b21c79ef36a\/\">is discontinued<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Known bug when trying to edit DTS packages: described here, but the two links in the article &#8211; Microsoft SQL Server 2008 Feature Pack page and Feature Pack for Microsoft SQL Server 2005 page. Microsoft SQL Server 2005 Backward Compatibility Components available on both links, but only on the second one it will work with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[37],"tags":[],"class_list":["post-231","post","type-post","status-publish","format-standard","hentry","category-s-sql-server-en"],"_links":{"self":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=231"}],"version-history":[{"count":1,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions"}],"predecessor-version":[{"id":432,"href":"https:\/\/eldar.pro\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions\/432"}],"wp:attachment":[{"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=231"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eldar.pro\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}