Hey guys,

I am very new, ie 1 hour so far, to DTS.

I have succeeded in creating a DTS thing which takes a csv file of
projects and imports it all into a temporary table in SQL Server.

What I wish to do, for say the Client column, is cycle through all the
rows and check if there is a client record in the db already and if so
insert the id value for this client. If there is not a client, I would
like to insert a new row into the client table and insert the id.

Can anyone help with this simple task?

Stuart

Guys,

I have found where I think I will do this, there is code like the
following;

Function Main()


DTSDestination("BidNumber") = DTSSource("BidNumber")
DTSDestination("Client") = DTSSource("Client")
DTSDestination("Project") = DTSSource("Project")
DTSDestination("JobStatus") = DTSSource("JobStatus")
DTSDestination("BiddingOffice") = DTSSource("BiddingOffice")
DTSDestination("ProductType") = DTSSource("ProductType")
DTSDestination("Priority") = DTSSource("Priority")
DTSDestination("JobType") = DTSSource("JobType")
DTSDestination("ITTDueDate") = DTSSource("ITTDueDate")
DTSDestination("AwardDate") = DTSSource("AwardDate")
DTSDestination("WorkStartDate") = DTSSource("WorkStartDate")
DTSDestination("Go(%)") = DTSSource("Go(%)")
DTSDestination("Get(%)") = DTSSource("Get(%)")
DTSDestination("PursuitLeader") = DTSSource("PursuitLeader")
DTSDestination("ProposalEngineer") = DTSSource("ProposalEngineer")
DTSDestination("ProjectLocation") = DTSSource("ProjectLocation")
DTSDestination("BusinessLine") = DTSSource("BusinessLine")
Main = DTSTransformStat_OK
End Function

How do I search another table to see if the other table contains the
value in DTSSource???

Hello StuartGMilton,

You could of course use Lookups but this over a large input recordset will
be painful.

What I would do is import the file to a working table first and then use
TSQL to do the comparisons and actions based on the comparison.

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