Forum Replies Created

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

  • RE: Extract filename from fully qualified path

    Path:

    SELECT substring(filename,1,charindex(reverse(substring(reverse(filename),1,charindex('\',reverse(filename)) ) ),filename) )

    FileName:

    SELECT RIGHT([FileName],CHARINDEX('\',REVERSE([FileName]),-1 )) AS NameOfFile FROM SSIS_LogFileNameRecord

    September 28, 2015 at 3:52 am

    #1829820

  • RE: Extract filename from fully qualified path

    SELECT RIGHT([FileName],CHARINDEX('\',REVERSE([FileName]),-1 )) AS NameOfFile

    September 28, 2015 at 3:34 am

    #1829817

  • RE: Backup job scheduling

    Hi

    Thing is I need to schedule a job so that, backing is done every day at 5:00pm. I can write a stored proc for this. But doesn't know how to...

    November 23, 2011 at 11:01 am

    #1412371

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