All under Queries tab,

click on  Parse/show parameters.

You will see a list  under destination column and parameters.

Eg. your update statement has 8 ?s, so there will be 8 parameters.

polulate destinations fields...

Frank, try this:

insert into rp_work3

(type, currdate)

select

posting_revenue4.record_type,

posting_revenue4.tran_date

--in DDQ, ? = source parameters in the same order as in transformation tab.

UPDATE tblPeople

SET Address1 = ?,

Address2 = ?,

Address3 = ?,

City =?,

State =?,

PostalCode =?,

Country...

As you can see I never work with foxpro before

cheers

and a.pk <> b.pk -- Minor change

This won't work, it does not return unique duplicates.

In sql2000 @@DBTS will change anytime a user on any connection makes a change to the

state of any table that has a timestamp column. It just gives you what the

last timestamp...

It shouldn't make any difference as long as pk is unique I think!!

did it work??

something like this?

select distinct a.patient, a.invoice,  b.patient, b.invoice

from table a

   , table b

where a.patient <> b.patient

and a.invoice = b.invoice

and a.pk < b.pk

order by a.invoice

I just rewrite the query to remove the commas.

select Nr_

     , ltrim(substring(weight, 1, patindex('%,%',weight)  - 1)) + ltrim(substring(weight, patindex('%,%',weight) + 1, datalength(weight))) as weight

from Artikel

I just thought the query maybe much better without using if-else, CASE etc..

select *

from tblparticipants

where varCategory is null

union

select *

from tblparticipants

where varCategory = @varCategory

Yep BULK INSERT is faster than BCP IN.

BCP is good when export data (ie BCP OUT).

You may reconsider using BCP out and Builk insert over DTS depending the load of transformations.

IF transformation...

ini file in this format (not include comments)

[my_var]                                        -- selection = my_var

test_str=select * from sysobjects       -- key = test_str

In dynamic property go global variables - > set value (open ini file)...

Have you tried using data driven task?

Not sure why your store.delday does not contain the actual date. I would much easier to query.

Anyway, hope this would help.

CREATE TABLE #magic (day_no int, wd char(3))

GO

insert #magic select 1,'sun'

insert...

I did a quick test and one way to get around is to create a proc.

eg.

CREATE PROC dbo.my_test @my_str varchar(500)

AS

exec(@my_str)

GO

1. create a global variable (string type) assign value from ini file.

2....