Post reply

Breaking down a string...

  • June 15, 2007 at 8:27 am

    #117439

    Hi, im new to ssis,

    i have a variable which is a string holding a filename e.g. " VUK124937.txt " and i need another variable to locate the first 3 characters of the string.

    any help appreciated.

     

    Scotty

  • June 15, 2007 at 8:39 am

    #713271

    Create another variable which uses an expression. There are many string functions avaliable such as substring which will to the trick. See the Expressions editor.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 15, 2007 at 8:50 am

    #713273

    thanks, i appreciate that,

    im having a little trouble in forming a suitable expression if anyone can help me.

     

    Scotty

  • June 15, 2007 at 8:53 am

    #713275

    Is would be SUBSTRING(@[System::MachineName], 1, 3)...

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • June 15, 2007 at 8:57 am

    #713279

    Thankyou so so much!!!

     

    Scotty

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

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