Post reply

Integration task

  • October 20, 2008 at 6:32 am

    #200147

    On one of the projects that I'm responsible for, we have to do one way integration and I'd like to get some ideas from anyone who's done it before.

    There are 5 XML files which will be FTP'ed to a drive on our network every 30 minutes. We have to pick them up and integrate the data into our tables. There will a lot of intelligence involved and big amounts of data. We're using SQL Server 2005 and the front end is a web application built in MS Visual Studio 2008.

    Any ideas what to use for the integration? An SSIS package? A .Net dll? A couple of stored procedures?

    Thanks!

  • October 20, 2008 at 6:41 am

    #887069

    there is FTP Tasks,also use XML Source Adapter in SSIS 2005. for xml files.

  • October 20, 2008 at 6:53 am

    #887075

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

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

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