Post reply

passing date parameter in ssis 2008 at run time

  • August 3, 2013 at 7:13 pm

    #297169

    hi again,

    i need to run data parameter in ssis 2008 through BIDS

    For example, the package contains dumping the data into table when u select 1st april, 2013.

    then the data should be extracted for previous 3 months (1-jan-2013 to 31-mar-2013)

    regards

    shaun 2012

  • August 4, 2013 at 9:03 pm

    #1638510

    Need cheap SQL Server 2008 Standard Product Key[/url]

  • August 5, 2013 at 8:51 am

    #1638632

    You can pass the rundate dynamically using SSIS package config file.

    When you run SSIS package, it first checks the variable/property values in config file. If found any, it will over ride the default values.

    Thanks,
    Naveen.
    Every thought is a cause and every condition an effect

  • August 5, 2013 at 12:00 pm

    #1638689

    Hi,

    Could you be a little more elaborative?

    Assuming that you have difficulty passing the date,

    1. I'd suggest : Use an sQL query to get the first day of the current month and pass it to an output variable in SSIS.

    2. Depending on the variable, calculate a start range( Current month -2months). Assign it in other variable and use it in your SQL query to get data between the ranges.

  • August 6, 2013 at 8:15 am

    #1638948

    i had created variable but not sure how to use it in the execute sql task query.

    I had created varriable

    Mydate as datetime- data type.

    and i have execute task to delet record as

    delete from abc where year(admit_date) = year('2013/01/01')

    ..

    So i want to replace

    '2013/01/01' with Mydate variable..

    Shaun..

  • August 7, 2013 at 1:04 am

    #1639233

    in the area where you give SQL query say,

    "delete from tableA where createdate= ? "

    and in parameters tab in the source editor, please add an input parameter. user::Mydate is the variable in ssis which u can pass as parameter.

  • August 7, 2013 at 7:25 am

    #1639361

    thank you so much, it is working now..

    Shaun..

Viewing 7 posts - 1 through 6 (of 6 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy