Post reply

Create packages programmatically - help needed with ScriptTask, TransformationTask

  • January 9, 2008 at 2:46 pm

    #120195

    Hi all,

    I have to create SSIS packages from my C# code; I'm looping through a folder and creating a package per DBF file.

    So far so good, but now I have to add a script that checks for valid dates and performs the correct transformation.

    The documentation (MSDN, google) on these topics (ScriptTask, ScriptComponent, Transformation) aren't really great and maybe you can help me or give me an advice how to accomplish this task.

    Thanks,

    robert.oh.

    *-- robert.oh. --*

  • April 28, 2008 at 8:59 pm

    #808104

    hi robert,

    i was having the same problem as you too, and couldn't find any answer. after a few days, i came to a conclusion and i hope this can help you.

    if we need to create scriptcomponent programmatically for over and over again, it means that the code inside scriptcomponent has a pattern. instead of writing it programmatically, you better creating a custom SSIS component.

    so you can create the component from your c# code.

    [reduce, reuse, recycle]

    [reduce, reuse, recycle]

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

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