Hi everyone,
I´m having a problem in DTS with making the loading
through DDQ!! It doesn´t give my any errors but the fact
is that it doesn´t load me anything!!
I have the following code:
Function Main()
DTSDestination("chave_artigo")=DTSGlobalVariables
("@chave_artigo")
DTSDestination("artigo") = DTSSource("artigo")
DTSDestination("descr") = DTSSource("descr")
DTSDestination("descr_pos") = DTSSource("descr_pos")
DTSDestination("cod_seccao") = DTSSource("cod_seccao")
DTSDestination("cod_familia") = DTSSource("cod_familia")
DTSDestination("cod_sub_familia") = DTSSource
("cod_sub_familia")
......
if IsEmpty(DTSLookups("existe").Execute(DTSSource
("artigo"))) then
DTSGlobalVariables
("@chave_artigo").Value=DTSGlobalVariables
("@chave_artigo").Value+1
Main=DTSTransformStat_InsertQuery
else
DTSGlobalVariables("@artigo_1") = DTSSource("artigo")
DTSGlobalVariables("@chave_artigo_2")=DTSDestinati on
("chave_artigo")
.......(store procedure call)
Main=DTSTransformStat_UpdateQuery
end if
End Function


And my insert clause is:

INSERT
INTO ARTIGO_DM
(chave_artigo, artigo,
descr, descr_pos, cod_seccao, cod_familia,
cod_sub_familia,
cod_und_base, marca, und_media_capac, und_med_venda,

fact_conv_capac, gama_preco, tipo_shopping,
grau_visibilidade, permanente, situacao,
cod_dir_comercial,
dir_comercial, cod_segmento_mercado,

segmento_mercado, cod_grupo_categoria, grupo_categoria,
seccao,
familia, sub_familia, und_base, divisao, cod_divisao,
cod_departamento,

departamento, tp_marca, cod_familia_parcial,
cod_sub_familia_parcial, cod_und_base_parcial,
fornecedor_prior,
manutencao_geral)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,

?, ?, ?, ?, ?, ?, ?, ?)

Help me,...please....
Kind Regards,
Lucinda