Welcome to Sign in | Help

modificare DTS Package

  •  02-02-2007, 4:08 PM

    modificare DTS Package

    salut, nu prea stiu cum functioneaza DTS-urile astea si am o problema...de exemplu el face

    INSERT INTO Customer
    (Part,Number)
      SELECT DISTINCT
    Part,Number
    FROM Tmp

     cum pot face sa vad cate distinct nu introduce el....un count ceva de genul ma gandesc

    declare @var1 as int,@var2 as int

    set @var1 = (select count(*) from Tmp)
    set @var2 = (select distinct count(*) from Tmp)
    select  REZ = @var1 - @var2

     cum sa fac sa vizualizez chestia asta acest REZ...tinand cont ca trebuie sa o introduc in acest DTS

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems