0

I need to know, where I can see these packages under SSMS 2012 while connecting to server where DTS packages are actually stored.

As this is first time I am going to play around DTS packages so not sure what server type (databse engine, integration serve etc) I need to select while connecting.

user948401
  • 31
  • 6
  • So you are connecting to a SQL 2000 Server? Do you mean DTS or SSIS? There is a big difference – Nick.Mc Feb 17 '15 at 06:25
  • Yes I have name of DTS packages only not SSIS. Now I am clueless where to find these packages after connecting it to Server. As this is first time I am going to play around DTS packages so not sure what server type (databse engine, integration serve etc) I need to select while connecting. – user948401 Feb 17 '15 at 06:36
  • This link (the first that came up when I searched) describes how to view them in SQL 2008 R2 SSMS. You might need to install that. https://technet.microsoft.com/en-us/library/cc645945(v=sql.105).aspx – Nick.Mc Feb 17 '15 at 10:03
  • I'm going to ask again so begging your pardon but are you talking about DTS, which was what we built in SQL Server 2000 and used Enterprise Manager/Query Analyzer to interact with, or DTSX aka SSIS which is new with 2005. Your question tags seem conflicted. – billinkc Feb 17 '15 at 14:50
  • If you are going with DTS, why? That product is dead, amazingly dead. They took out support within SSIS after 2008 for DTS and even then it was a bit of a bear to get it working (separate install). What compelling business reason do you have to push so much risk onto your client by using a dated, unsupported technology? – billinkc Feb 17 '15 at 14:52
  • Exactly you are right, I just wanted to view legacy DTS package in SSMS 2012 then I will rewrite my new SSIS packages. But problem is that I am not able to view DTS packages in SSMS 2012. @Nick.McDermaid your link is good but I am expecting the same reference for 2012 version. – user948401 Feb 17 '15 at 17:34
  • I'm fairly certain the functionality doesn't exist in 2012 – Nick.Mc Feb 17 '15 at 22:31

0 Answers0