Post reply

using a variable to specify the destination database files in the transfer database task editor

  • July 20, 2006 at 7:59 am

    #114804

    Here is what I am trying to use:

    "'" + @[User::ShowDestData] + "','F:\\SQL Databases','';" + @[User::ShowDestLog] + "'D:\\SQL LogFiles',''"

    But it seems to want to force that i use double quotes instead of single quotes and I cannot figure out hot to insert a single quotes into the expression value... I've tried """ but it dosent work.

    Any ideas...

  • July 21, 2006 at 5:46 am

    #650634

    Inside the double quotes you can mention single quote. the expression language uses C#. all strings are considered as double quotes so u have to start the expression with double quote if the value is constant

  • July 21, 2006 at 7:38 am

    #650686

    I'm not understanding that at all.

  • July 21, 2006 at 8:14 am

    #650718

    figured out how to get the string formatted the way I want, but still did not work.

    Anyone have an idea how to solve this problem:

    need to copy a database using a dynamic value as the new database name (along with filepath).

    thanks

  • July 21, 2006 at 12:33 pm

    #650823

    Your single quotes don't match, and I'm not sure whether single quotes would work anyway.

    You need to use double quotes.  To use them in an expression you must escape them with \, using two of them in a row doesn't work.

    I think your expression should be:

    "\"" + @[User::ShowDestData] + "\",\"F

    :\\SQL Databases\",\"\";\"" + @[User::ShowDestLog] + "\",D:\\SQL LogFiles\",\"\""

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

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