Post reply

dynamic property task with 2 parameters.

  • October 26, 2007 at 11:55 am

    #176604

    A DTS package has a dynamic property task with 2 parameters.

    select (year(getdate()) -1902) * 10000

    select ((year(getdate()) -1900)+4) * 10000

    The query is extracting data from AS400 to SQL2K

    select CWDATE,CWWKDY

    FROM PPTREASUSA.CLWORK

    where CWDATE > ? and CWDATE < ?

    My question is why is the parameters are trying to get only the year? It doesn't make sense to me.

  • October 26, 2007 at 12:56 pm

    #745892

    Look to me that they're looking to extract 5 year's worth of info?

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply