Post reply

Creating a dynamic directory

  • February 17, 2010 at 5:55 am

    #138278

    Hi,

    I want to create a directory everyday,name should be current date like '17022010'.Is it possible to create a directory like that?.Because i need to run a job everyday for creating a directory.Can anybody suggest regarding this one.

    Thanks in Advance.

    PRVR

  • February 17, 2010 at 8:12 am

    #1120120

    thanks to all who looked into my problem.I got solution for this problem.

  • February 17, 2010 at 8:14 am

    #1120122

    Can you describe the solution

  • February 17, 2010 at 8:21 am

    #1120134

    First you need to create a user defiend variable.Here I was created an expression with connection string like

    @[User::directory] +RIGHT("0"+ (DT_STR, 2, 1252) DAY( GETDATE() ),2 )+ RIGHT("0"+ (DT_STR, 2, 1252) MONTH( GETDATE() ),2 )+ (DT_STR, 4,1252) YEAR( GETDATE() )

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

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