Post reply

how can i pass date parameter to SSIS package

  • March 31, 2008 at 4:48 am

    #183926

    hi everybody,

    can anyone help me how can i pass date parameter to SSIS package???so that i can extract other information from that date,

    I am the beginner in SSIS,I am having DMTIME table and it contains following fields-

    TimeKey-Primary key

    FullDateAlternateKey-datetime

    DayNumberOfWeek

    DayNameOfWeek

    DayNumberOfMonth

    DayNumberOfYear

    WeekNumberOfYear

    MonthName

    MonthNumberOfYear

    CalendarQuarter

    CalendarYear

    CalendarSemester

    FiscalQuarter

    FiscalYear

    FiscalSemester

    I have to extract all this fields frm the date which i will pass,this same as AdventureWorks database DimTime table,but i am not geting how i can do it??please help me and tell me step y step procedure

  • March 31, 2008 at 5:21 am

    #795849

    A way here to work out would be to make a variable in the package which takes its value from the XML configuration file. You can use the variable in an execute SQL task to run the select query for fetching the desired data.

    The variable value can be changed in the configuration file each time before the package is executed.

  • March 31, 2008 at 6:18 am

    #795877

    hi,but how i can do it???

    i have following xml file,but please tell me step by step,how can i declare variale which access xml file,i have following xml file ,which is for Adventureworks database's DimTime table...

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

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