Post reply

rename file

  • August 6, 2011 at 12:09 am

    #245749

    hi all, i have some files in folder and each file name contains some text that i want to remove such as : dbo.filename.storedprocedure.sql

    i do not want to use ssis , please help me how can i remove unuseful text from file name from each file in that folder using stored procedure.

    thanks

    challenge everything

  • August 6, 2011 at 8:25 am

    #1364782

    Sorry, misread the question.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • August 6, 2011 at 10:45 pm

    #1364846

    So basically out of "dbo.filename.storedprocedure.sql" you want to remove everything but "filename"?


    Twitter: @SQLife
    Email: sqlsalt(at)outlook(dot)com

  • August 7, 2011 at 12:42 am

    #1364850

    it might be useful if you give an example such as

    Before : dbo.getallobjects.storeprocedure.sql

    After : sbo.getallobjects.sql

    The naming convention your using looks like the one VS uses when creating objects in a DB project. Please not VS needs the files in this convention i order to build and deploy.

    Jayanth Kurup[/url]

  • August 8, 2011 at 6:17 am

    #1365143

    What this one to do with T-SQL?

    Do you want to rename files?

    Jscript, VBScript, DOS Batch

    or best choice:

    PowerShell

    T-SQL is the language to manipulate with data in the relational databases. It's not designed to manipulate with files on drives... 🙂

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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