Post reply

Exec of store proc in ssis

  • July 28, 2011 at 10:20 am

    #254481

    Hi, i want to execute the store proc exec [dbo].[PartitionSwap] 'tablename', 2010-12-31T23:59:59.000 in SSIS.

    Actually i am trying to exec the given store proc by giving parameters. The store porc seems to be exec [dbo].[PartitionSwap] ?, ?. So i can assign variable to the parameters. but what the problem is am not able to take the datetime including with seconds like 2010-12-31T23:59:59.000. in SSIS.

    Will any one suggest me how can i include seconds in datetime. Plz, that would be great.

    thank you.

  • July 28, 2011 at 10:28 am

    #1360300

    do you mean seconds (:59 ) or milliseconds as well (:59.000) ?

  • July 28, 2011 at 10:32 am

    #1360307

    millis seconds as well..... the given date is my boundary value for my partitions. I need date including seconds to.

  • July 28, 2011 at 10:52 am

    #1360327

    sadly SSIS variavles only go down to 1 second intevals.

    one workaround to include milli-seconds is to convert the value to a Varchar and store this in a string variable and then covert back to time when you run the strored proc.

  • July 28, 2011 at 11:02 am

    #1360342

    I hope we cant convert varchar to datetime

  • July 28, 2011 at 11:04 am

    #1360345

    ok i dnt want milliseconds but it it possible to get above boundary without millis seconds. If yes how?

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

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