Create packages programmatically - help needed with ScriptTask, TransformationTask

• robert.oh.

  SSC Enthusiast

  Points: 129

  More actions

  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. --*

• hendrik.sudianto

  Grasshopper

  Points: 17

  More actions

  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]