May 31, 2012 at 2:48 am
Hi All,
How can we loop through multiple excel files if they are having different schema.
Thanks
May 31, 2012 at 8:43 pm
SQL* (5/31/2012)
Hi All,How can we loop through multiple excel files if they are having different schema.
Thanks
The standard Data Flow Task supports only static data flow definition at design time. You will have to create separate data flow for each schema you want to process.
There is also a third-party commercial solution provided by CozyRoc. We have implemented enhanced Data Flow Task Plus, which supports dynamic data flows at runtime. You can process all your schemas using one For Each Loop container and one Data Flow Task Plus.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy