DTS Project Template not available?

I need to import data from a CSV file into a db I'm designing. I figured I'd use DTS (which I understand now uses VS in the form of a 'Business Intelligence' (BI) project). My problem is that my only choices for BI projects are:

Analysis Service Project, Import Analysis Services 9.0 Database, Integration Services Project, Report Server Project Wizard, Report Model Project, Report Server Project.

No "Data Transformation Project".

I have SQL Server 2005 Developer's Edition. Might it be that DTS is not included in that version?

If I can't use DTS, what choices do I have?

It is included choose Integration Service Project but when you are importing CVS file into SQL Server, the server sees null values due to the nature of CVS files so it is a good idea to import your file into temp table before doing an INSERT INTO to your destination table. Try the link below for ready to use code but you can just use the GUI. The site is run by DTS expert. Hope this helps.

http://www.sqlis.com/

|||

Great, thanks! Yes, I have already created a 'temp' table as well as my ultimate normalized tables.

I'll check out that site.

DTS in SQL Server Workgroup or Personal Edition?

Hi,
I see that DTS is not available in the Workgroup edition of SQL server.
Does anyone know if it's available in the Personal edition?
If DTS is not available in an edition of SQL server, can I still use DTSPUMP
functions in VB on the SQL server?
Thanks in advance,
--
Christy Warner
www.autoaudit.comHi
DTS is supported on personal edition although the following link does not
include the new workgroup edition, I would expect it to at least have
deployment capabilities so you should be able to distribute your application
s.
http://msdn.microsoft.com/library/d...br />
1cdv.asp
You may want to confirm this with you vendor or local Microsoft office.
John
"ChristyWarner" wrote:

> Hi,
> I see that DTS is not available in the Workgroup edition of SQL server.
> Does anyone know if it's available in the Personal edition?
> If DTS is not available in an edition of SQL server, can I still use DTSPU
MP
> functions in VB on the SQL server?
> Thanks in advance,
> --
> Christy Warner
> www.autoaudit.com
>

DTS in SQL 2005 Standard

I'm using SQL 2005 Standard Edition with the Management Studio Console CTP but I can't seem access DTS functions. Is DTS available in this edition of SQL?

I just got through the same issue. I upgraded from 2000 to 2005 and could no longer find DTS. It is now SSIS in 2005. I can point you in the right direction but thats it. I am still figuring it out in the new edition.

-M

|||

here was my thread

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=349970&SiteID=1

DTS in SQL 2005

Not sure why Microsoft would remove from SQL 2005 DTS import data
sources all the default drivers available to ODBC but they did. In SQL
2000 the drivers available to ODBC were by default available to DTS
import. How does one go about getting DTS to recognize these drivers
so simple data import can be accomplished.
To import from a DBF file you now have to create an ODBC data source
Every time you want to add a new file and then to add insult to injury
they make you key in all the ODBC information for the import source
instead of giving you a simple drop down.
Seems like a huge step backwards as far as user interface goes.Hi
If I understood you correctly , you can run DTS (SS2000) from SS2005. There
is a folder called Legacy under Management folder.
<jmirsky@.hotmail.com> wrote in message
news:1139956308.785445.51930@.g43g2000cwa.googlegroups.com...
> Not sure why Microsoft would remove from SQL 2005 DTS import data
> sources all the default drivers available to ODBC but they did. In SQL
> 2000 the drivers available to ODBC were by default available to DTS
> import. How does one go about getting DTS to recognize these drivers
> so simple data import can be accomplished.
> To import from a DBF file you now have to create an ODBC data source
> Every time you want to add a new file and then to add insult to injury
> they make you key in all the ODBC information for the import source
> instead of giving you a simple drop down.
> Seems like a huge step backwards as far as user interface goes.
>

DTS in SQL 2005

Not sure why Microsoft would remove from SQL 2005 DTS import data
sources all the default drivers available to ODBC but they did. In SQL
2000 the drivers available to ODBC were by default available to DTS
import. How does one go about getting DTS to recognize these drivers
so simple data import can be accomplished.
To import from a DBF file you now have to create an ODBC data source
Every time you want to add a new file and then to add insult to injury
they make you key in all the ODBC information for the import source
instead of giving you a simple drop down.
Seems like a huge step backwards as far as user interface goes.
Hi
If I understood you correctly , you can run DTS (SS2000) from SS2005. There
is a folder called Legacy under Management folder.
<jmirsky@.hotmail.com> wrote in message
news:1139956308.785445.51930@.g43g2000cwa.googlegro ups.com...
> Not sure why Microsoft would remove from SQL 2005 DTS import data
> sources all the default drivers available to ODBC but they did. In SQL
> 2000 the drivers available to ODBC were by default available to DTS
> import. How does one go about getting DTS to recognize these drivers
> so simple data import can be accomplished.
> To import from a DBF file you now have to create an ODBC data source
> Every time you want to add a new file and then to add insult to injury
> they make you key in all the ODBC information for the import source
> instead of giving you a simple drop down.
> Seems like a huge step backwards as far as user interface goes.
>

DTS in SQL 2005

Not sure why Microsoft would remove from SQL 2005 DTS import data
sources all the default drivers available to ODBC but they did. In SQL
2000 the drivers available to ODBC were by default available to DTS
import. How does one go about getting DTS to recognize these drivers
so simple data import can be accomplished.
To import from a DBF file you now have to create an ODBC data source
Every time you want to add a new file and then to add insult to injury
they make you key in all the ODBC information for the import source
instead of giving you a simple drop down.
Seems like a huge step backwards as far as user interface goes.Hi
If I understood you correctly , you can run DTS (SS2000) from SS2005. There
is a folder called Legacy under Management folder.
<jmirsky@.hotmail.com> wrote in message
news:1139956308.785445.51930@.g43g2000cwa.googlegroups.com...
> Not sure why Microsoft would remove from SQL 2005 DTS import data
> sources all the default drivers available to ODBC but they did. In SQL
> 2000 the drivers available to ODBC were by default available to DTS
> import. How does one go about getting DTS to recognize these drivers
> so simple data import can be accomplished.
> To import from a DBF file you now have to create an ODBC data source
> Every time you want to add a new file and then to add insult to injury
> they make you key in all the ODBC information for the import source
> instead of giving you a simple drop down.
> Seems like a huge step backwards as far as user interface goes.
>