DTS - Import Text file and update records
Posted on 2006-04-06
I am attempting to create a DTS package that will import a text file and update the records.
The text file has two columns:
col001 -> numID
col002 -> y/n
The db table has:
So, col002 if it is y it will update accept is no - it will update declined.
Here is my code:
Select Case ("PolicyNumber")
If ("Col003" = "Y" )then
DTSDestination("Accepted").Value = DTSSource("Col3").Value
DTSDestination("Declined").Value = DTSSource("Col3").Value
Main = DTSTransformstat_UpdateQuery
Now, when i got into Queries, i don't have any parameters. How do i get them to show up or set them up?