September 27, 2012 at 9:04 am
I cannot find exactly what I am looking to know regarding SQL Server 2008 Express R2 and support for DTS Packages. Can I install SQL Server 2008 Express R2 on my laptop and connect to an instance on a remote server that has been configured to run DTS packages and run a DTS package from Express?
Is there a download for SQL Server Express 2008 R2 that provides support for running backward compatability SQL 2000 DTS packages?
Thank you very much.
Patti
September 27, 2012 at 10:51 am
Patti Johnson (9/27/2012)
I cannot find exactly what I am looking to know regarding SQL Server 2008 Express R2 and support for DTS Packages. Can I install SQL Server 2008 Express R2 on my laptop and connect to an instance on a remote server that has been configured to run DTS packages and run a DTS package from Express?Is there a download for SQL Server Express 2008 R2 that provides support for running backward compatability SQL 2000 DTS packages?
Thank you very much.
Patti
For SQL 2008 backward compatibility scenario DTS packages are run from the command line using dtsrun.exe. In your scenario where will the DTS packages reside? If they'll be stored in a repository on a remote server you could run dtsrun.exe locally and point it to that remote repository using /S. If the DTS packages are file-based and will be stored on the remote server where they are inaccessible directly from your machine then you would need to come up with a way to execute dtsrun.exe on the remote machine either through a Remote Call (e.g. using PowerShell) or via a SQL Agent Job configured on the remote instance.
There is a lot of info in Books Online about the different options. I could not find mention of Express Edition specifically as it relates to installing the DTS Runtime options but you may be able to install it from a higher Edition's media although I am not sure how that might be licensed so check with Microsoft if it comes to that:
Support for SQL Server 2000 DTS in SQL Server 2008 R2
Just checking, is upgrading to SSIS an option? 🙂 It opens up so many more options for you.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
September 27, 2012 at 11:01 am
Thanks I will take a look at the link. As far as upgrading to SSIS, the developer has a learning curve so they want to upgrade to 2008 with backward compatibility first and then convert everything to SSIS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply