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 if .. do somthing

How I can do If instruction in DTS ??

example

select @.data=date form table where id=32

if @.data='2007-10-22'

copy data to exel from table2 (I have this in 3 elements(OLE DB Source,Data Conversion,Flat File Destination)

else

do nothing

I don't now how to do if instraction.

Pleas help me.

FYI - Did you know that DTS has been deprecated, and that SSIS is the new approach?

|||I have register my dts in sql server ...|||

Don't use an if statement, build the conditional logic into the where clause of your select statement.

select * from select table where id=32 and date='2007-10-22'

Copy whatever is found in the next step in the process flow. If no data is found, nothing will be copied.