Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Custom task Creation IN SSIS

Answered Custom task Creation IN SSIS

  • Sunday, January 27, 2013 12:34 PM
     
     
    Sign In to Vote
    0

    Hi,

    Currently i build some 40 odd ssis packages to dump data from 40 different files. Now we got a requirement where we have to process another 40 files. But this time the requirement has changed like this " Create only one custom component in ssis which will read the 40 files and dump the data into db rather than creating one one SSIS packages for 40 different files. So that if in future any more file will come we don't have to create ssis package for that. Its the custom component which will take of that new file."

    Please suggest me how to proceed for the same.

     

All Replies

  • Sunday, January 27, 2013 12:52 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    If the 40 files have the same layout then you can use a foreach loop:
    http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html

    And if the 40 files have different layout, but you need to do the same actions for each file then you can use BIML to create packages automatically:
    http://bidshelper.codeplex.com/wikipage?title=Biml%20Package%20Generator

    Creating a custom component for this doesn't sound like the right solution.

    Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

     
  • Sunday, January 27, 2013 3:09 PM
     
     Answered
    Sign In to Vote
    1

    Hi,

    Currently i build some 40 odd ssis packages to dump data from 40 different files. Now we got a requirement where we have to process another 40 files. But this time the requirement has changed like this " Create only one custom component in ssis which will read the 40 files and dump the data into db rather than creating one one SSIS packages for 40 different files. So that if in future any more file will come we don't have to create ssis package for that. Its the custom component which will take of that new file."

    Please suggest me how to proceed for the same.

    If you have to process 40 files with different number of columns, I would recommend you check the commercial COZYROC Data Flow Task Plus. It is an extension of the standard Data Flow Task and supports dynamic columns at runtime. You can process all different files with only one For Each Loop Container and one Data Flow Task Plus in it. No programming skills are required.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

     
  • Monday, January 28, 2013 2:54 PM
     
     
    Sign In to Vote
    0
    Thanku for the suggestion. All the files would be having different layout. I ll try the second suggestion.
     
  • Monday, January 28, 2013 2:55 PM
     
     
    Sign In to Vote
    0
    Thanku ll try and let u know.