Post reply

How to execute all sql query within a folder in SSIS

  • July 29, 2009 at 9:52 pm

    #135032

    Hi ,

    I want to execute multiple sql queries from any folder, I don't know how many sql queries in the folder ....I need to execute all one by one dynamically .Is threre any way for it through sql task ,i can execute one sql query in a perticular time.

    tnx

  • July 30, 2009 at 3:54 am

    #1032248

    aktajay (7/29/2009)

    Hi ,

    I want to execute multiple sql queries from any folder, I don't know how many sql queries in the folder ....I need to execute all one by one dynamically .Is threre any way for it through sql task ,i can execute one sql query in a perticular time.

    tnx

    I think you can add a foreach loop container, set the type to File enumerator, store the file name and path in a variable then use the execute sql task setting the SQLSourceType to a file connection.

    In your file connection create an expression which sets the value of the ConnectionString property to be the value of the variable you set in the foreach enumerator.

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

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