March 31, 2009 at 12:23 pm
hi,
We are performing in-place upgrade from sql 2000 to 2005. We have DTS packages.Could you please tell me at what step do we need to install sql server 2000 DTS designer components.
1.Perform inplace upgrade
2.Install SP3
3.Do all post migration steps
4.Install DTS designer components
is this the correct order? I followed the above order and everything worked fine But after 2 days, when I was trying to edit the package its again asking me to install DTS Designer components?
please advice me
March 31, 2009 at 1:03 pm
AFAIK you only need to install the backward components if you want to be able to modify the packages.
Keep in mind to put your DRP for this upgraded server in place.
If you need to rebuild it from scratch (having only the backup files to fall back to), you need to first install sql2000, modify its settings as desired, then upgrade to sql2005 and then restore all databases :sick:
You need this to ensure all security settings, ... are still open to your sqlinstance.
That's why I always advise to migrate side by side or on a completely new server.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 31, 2009 at 1:43 pm
Thank you.
If you not migrating the DTS to SSIS and want edit the DTS packages in sql server 2005, we need to install DTS designer components (sqlserver2005_dts.msi) right?
And is there any option we need to choose to install backupward components while installing sql server 2005? If there is an option and if we choose that option to install, then no need to install DTS designer components?
please clarify me
March 31, 2009 at 2:07 pm
I don't recall an option during SQL 2005 installation that let's you install DTS Designer components. I've had to download and install them after the SQL installation.
Greg
March 31, 2009 at 11:43 pm
As Greg stated, it is an add on component after your sqlserver has been installed.
You can download it from Feature Pack for Microsoft SQL Server 2005 at http://www.microsoft.com/downloads/details.aspx?FamilyId=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
The component you want is called "Microsoft SQL Server 2000 DTS Designer Components"
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 2, 2009 at 6:32 am
I tend to istall the DTS Designer components on a new build after applying any SPs and CUs. But then a new SP or CU comes along and it gets applied on top of whatever is there, so it probably does not matter.
Many people find they need to apply the KB 917406 fix to get DTS Designer to edit all their packages on SQL 2005.
Also, if you are installing on a X64 box, then any DTS components that were put in the \System32 folder on a 32-bit box (e.g. OCX, etc) must instead be put in the \sysWOW64 folder on the 64-bit box.
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
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply