Intalled SQL Server 2005 Developer on my PC and the Bussiness intelligence
studio components for VS.net installed fine, except I don't see a template in
there for Data Transformation Services (DTS) project. Is that no longer
available or did I miss something on the install? And if the latter, where
can I get that template?

Thanks for any help on this!!
--
HEEEEEEEEEEEEEEEEEEEEEELP!!!

DTS does not exist by default in 2005. They have a new tool call Integration
Services that replaces it. If you look through documentation you will find
ways to allow DTS to run in 2005 until you convert to Integration Services.
There is a wizard for doing this conversion, but it may not convert
completly, what it can't convert it will put in a dts task that can be run as
long as you have done the seperate task of installing dts into 2005. But at
some point you will need to convert these items to Integrated Services. I am
trying to do that right now, but am not having a log of success in doing it.
Best luck to you

"sasquatch" wrote:

Hello sasquatch,

DTS is now called SQL Server Integration Services. You can, in BIDS, create
a project of that type. DTS is still around techically.

In the install it gave to you the chance to install the DTS 2K runtime.
This willl allow you to fire DTS packages from SQL Server 2K5. If you want
to edit 2000 packages and still keep them as 2K packages then you need to
install a tool from the feature pack which is found here

http://www.microsoft.com/downloads/d...displaylang=en


You can also choose to migrate 2K packages to 2K5. This is not always a
complete conversion and it may/may not turn out the way you thought. The
more complex the package the less likely the migration wizard can do a full
job.

Here are some links about the migration wizard.


http://wiki.sqlis.com/default.aspx/S...ionWizard.html

http://wiki.sqlis.com/default.aspx/S...zardSteps.html


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com