Post reply

HELP ME.....Urgent -----> SSIS

  • June 28, 2007 at 9:45 am

    #179593

    Hello All,

    I need an urgent help, please.

    All that I am doing is:

    (1) I wrote a simple SSIS package that takes data from oracle to sql2k5.

    (2) I compiled the SSIS package.

    (3) The packge has to be run in a frequency of 3 times a day and I would like to run this through a service.

    (4) In my service program,

            I am calling the package and added the following 4 libraries so that the package will work.

         Microsoft.SqlServer.DTSPipelineWrap.dll, Microsoft.SqlServer.DTSRuntimeWrap.dll, Microsoft.SQlServer.ManagedDTS, Microsoft.SqlServer.PipelineHost

    Now, I compiled the program in 'Release' mode and trying to install the service. I am getting the following error when I tried to install the service.

    "Error while installing ........"msxml16.dll' not found. Contact System Administrator.....Registry........"

    I tried to download for the msxml16.dll and where I can get it from?

    Any help will be highly appreciated.

    Regards

    Ram

  • July 9, 2010 at 1:32 pm

    #1190998

    Must this run from a service? Can you schedule as a job? If you're using some sort of trigger/logic in your service to fire the execution of the package you may be able to use Workflow Foundation via .NET.

    If you supply some additional info I may be able to assist more.

  • July 12, 2010 at 12:25 am

    #1191321

    Please use SSMS-Jobs scheduling, this is the best way to do it.

  • July 12, 2010 at 2:14 am

    #1191346

    SQL Server Agent, but be sure you have enabled the Agent from Configuration Manager

    :cool::cool::-)

    Raunak J

  • July 13, 2010 at 9:14 pm

    #1192492

    The best way is to schedule as a job and run the package.

  • July 13, 2010 at 10:23 pm

    #1192507

    Yes schedule the ssis-job is the best way to do it.

    Thanks

    Ragavan Ramu

Viewing 6 posts - 1 through 5 (of 5 total)

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