Create SSIS Package Programatically

  • Hello All,

    I am interested in creating SSIS packages programatically using Visual Basic. I am not familiar with Visual Studio (beyond it's role in creating SSIS packages) but my shop has it so I intend to use it if possible. Does anyone have a good tutorial on how I can get started on this? I read through the page at http://msdn.microsoft.com/en-us/library/ms135946.aspx but couldn't even get their simple snippet working in Visual Studio 2005. Any pointers would be greatly appreciated, I'm not sure where to start.

    Thanks so much!

  • Learning to use Visual Studio is the least of your worries in my opinion. I assume you have not coded before using VB.NET (unless you did it using another IDE - unlikely) also.

    Using Visual Studio, coding in VB.NET and programmatically creating SSIS packages are 3 very different things. The last one is not trivial and very annoying.

    See the following post for an overview of the last one:

    http://www.codeproject.com/KB/database/Digging_SSIS_object_model.aspx

    As for learning to use Visual Studio, I'd just watch some videos and/or follow online tutorials. Try here:

    http://windowsclient.net/

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

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