Forum Replies Created

Viewing 15 posts - 376 through 390 (of 669 total)

  • RE: Check for pattern in SSIS

    Regex newPattern=new Regex("[0-9]+[-][0-9]+[-][0-9]+")

    Explanation: not beginning with alphabets and having atleast one occurance or more of numeric followed by dash(hyphen) which is followed by one or more occurance of numerals again...

  • RE: Data warehouse design template

    The best is as Steve suggested...

  • RE: Update a variable in SSIS

    Phil Parkin (9/24/2010)


    Raunak Jhawar (9/24/2010)


    (and admit, VB or C# is probably a lot easier than WQL :-D)

    -- ...try something new everyday...;-)

    One day a German beer, then a Belgian one, then...

  • RE: Update a variable in SSIS

    (and admit, VB or C# is probably a lot easier than WQL :-D)

    The learning process should be gradual and rising...that's what is my personal belief...try something new everyday...;-)

  • RE: vs_NeedsNewMetadata

    What is the value set for ValidateExternalMetaData?

  • RE: Update a variable in SSIS

    class Program

    {

    static void Main(string[] args)

    { ...

  • RE: Performance Point 2010 forum

    Come on guys let's gear up...

    Please raise this issue...invite talent..:-):-):-)

  • RE: Update a variable in SSIS

    da-zero (9/24/2010)


    Or, just to add another option:

    1. Add a script task.

    2. In the script, create a directoryinfo on the directory. (let's name it di)

    3. Use the getfiles method: di.getfiles() and...

  • RE: SSAS question

    amarsale (9/24/2010)


    Hi,

    i have been asked to build a datawarehouse cube which includes data from three product master tables. So i have to bring together each product that exists in all...

  • RE: Update a variable in SSIS

    Always happy to help!!:-):-):-)

    Please follow here

    OR

    Please follow here

  • RE: Update a variable in SSIS

    Doug,

    You have 2 options at this point of time:

    Option 1: Use WQL Query and trigger on FileCreate Event

    OR

    Option 2: Use FileSystemWatcher in Script Task and trigger on FileCreate Event

    Both are...

  • RE: Update a variable in SSIS

    doug.milostic (9/23/2010)


    I have an FTP folder into which an application creates files on a daily basis. I only want to download the last file created. The files are named numerically...

  • RE: Reporting Services Date Problem

    You may use the String.Format() method available is SSRS

    for more customization i would suggest using an embed VB code

  • RE: Update a variable in SSIS

    You may store the variable value Post Execution in some another variable which will be accessed in the next script task...

    But what is it that you wish to achieve

  • RE: Update a variable in SSIS

    The behaviour is perfectly normal. The variable is losing the scope as it is not persistent as the process terminates

Viewing 15 posts - 376 through 390 (of 669 total)