Post reply

Executing SSIS Package from VB.NET

  • February 12, 2009 at 7:10 am

    #197147

    Hi,

    My current VB.NET (2003) code is till now executing DTS packages. As all my DTS packages are migrated to SSIS packages, I am now checking whether the same current code can execute SSIS packages with out any code changes.

    (Note : Migrated SSIS package name is same as the old DTS package name)

    Here is my current code snippet:

    Imports System.Runtime.InteropServices

    Imports DTS

    .....

    ...

    ..

    pkg.LoadFromSQLServer(server, uid, pwd, _

    DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, _

    "", "", "", strDTSPackageName, Nothing)

    pkg.Execute()

    ..

    ..

    Do I require any code changes? If so pls guide me.

    I am not sure whether this forum is the right place to post this query. If not sorry for the inconvenience.

    Thanks in advance,

    Suresh

    Regards,
    Suresh Arumugam

  • February 12, 2009 at 3:24 pm

    #943237

    The first thing I can see is that you'll need to import a different namespace for SSIS. There are probably some other things that are different also. Have a look at the following link.

    http://msdn.microsoft.com/en-us/library/aa337077.aspx

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

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