Post reply

How to get file name in SSIS user variable

  • April 3, 2015 at 3:30 am

    #302727

    Hi ,

    I am looking to achive below scenario in my ssis package.

    I am having folder structure like I:\\Incomingfiles\

    where source file are get placed at regular interval. file structure like EMP_150403145782

    I want to capture filename in ssis variable.

    I am having stored procedure where I have to set the value of file name.

    please help me to achieve the same

    thanks & regards,

    Vipin Jha

  • April 3, 2015 at 12:00 pm

    #1788642

    If I understood the question correctly this should be a trivial task using a ForEach folder enumeration, have a look at this article: Implementing Foreach Looping Logic in SSIS[/url]

    😎

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

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