SQL Server Performance Forum – Threads Archive
reading DTS packages stored in SSF format
I have saved a DTS package in SSF format (Structured Storage File). Is there anyway I can recreate the DTS package from this file? Is there any utility that will allow me to read in the DTS package in SSF format and edit it? Thank You,Jethro
Use DTS designer to edit the DTS package and do not use other tools to invalidate the compatibility of DTS package. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Open EM. Open server group then click open your server folder. Right click on "Data Transformation Services". Choose Open package. I hope this is the answer to your question.
MMAROVIC, You are the man. Thank you for giving such a direct answer to a simple question. I knew there was some easy way of doing this but just couldn’t or didn’t notice that one particular option in EM. Thanks for not asking me all kinds of questions about what, why and when or providing all kinds of enlightening insights into the workings of the universe before giving the answer. Sometime I get so tire of all the back and forth that goes on before a solution is provided. I know sometimes that’s necessary to find the solution but I find people don’t read what is being asked sometimes and just go off on a tangent. Thanks again,
Jethro
quote:Thanks for not asking me all kinds of questions about what, why and when or providing all kinds of enlightening insights into the workings of the universe before giving the answer.
You are welcome. That (asking questions and offering opinion) is something I do quite often when I don’t understand question but still try to help or when I don’t agree with the way someone want to solve the problem.
Your question was:quote:I have saved a DTS package in SSF format (Structured Storage File). Is there anyway I can recreate the DTS package from this file?
so I was not sure if you really asked for a way to open saved package. That’s why I said:quote:I hope this is the answer to your question.
I know it can be annoying when you ask something and receive answers that are not related to a problem you try to solve, but keep in mind that people are trying to help based on their understanding of your post. Although, I must admit it happened to me more then once that I answered not reading the question carefully enough and I was way off. I changed my approach recently; hopefully it will lead to less misunderstanding.]]>