Load no of Sql files into a single File by Order:
1. For the above task we have created Flat File source and Flat File Destination.
2.In the Flat File source we will give location of one of the sql File Name.
3.In the Flat File Destination we will give location of one of the sql File Name where we stored sql file
4.Then the Data Flow Task is Inserted into a For EachLoop Container.
5. then we Created three Variables.
6.Then add Execute SQL Task to the For Each Loop Container and gave Excel connection manager.in this Excel we will give the order for scripts storage.
7.and configure the Result set as Full result set.
8.After configure the For Each Loop Container as fallow below.
9.then select source connection and press F4 button -> go to ->Expression.set conn strg as fallows.
10. then Finally press debugging we get the Result.
1. For the above task we have created Flat File source and Flat File Destination.
2.In the Flat File source we will give location of one of the sql File Name.
3.In the Flat File Destination we will give location of one of the sql File Name where we stored sql file
4.Then the Data Flow Task is Inserted into a For EachLoop Container.
5. then we Created three Variables.
8.After configure the For Each Loop Container as fallow below.
