Post reply

Setting a variable to an expression

  • May 28, 2010 at 4:11 pm

    #156989

    I'm trying to use a script to set the value of a variable to an expression. The code I'm using is below. What am I doing wrong?

    Public Sub Main()

    '

    ' Add your code here

    dts.Variables("varCurrentPeriod").Value = (DT_WSTR,4) FLOOR(DATEDIFF("mm", (DT_DATE)"27-Jan-1989",GETDATE()))

    '

    Dts.TaskResult = Dts.Results.Success

    End Sub

  • May 28, 2010 at 8:11 pm

    #1174200

    In your script task, did you set the variable to be read/write?

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 1, 2010 at 1:48 am

    This was removed by the editor as SPAM

  • June 1, 2010 at 12:36 pm

    #1174964

    Wow, that really worked! I've learned more about SSIS 2005 in the past month than in the previous 2 years! Thanks so much!

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

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