Post reply

create ssis package and read data from multi type file path .xls and .xml with sheduler

  • September 2, 2010 at 6:59 am

    #237771

    Hi Friends,

    Pls solve my following query with example.

    now i am doing project using ssis 2005. in that

    1. import data from multiple resources like .xls, .xml,db

    2.Read only file path from created meta data table like dil_table_met (Filetype=.xls,filepath=c:\..)

    3.In that meta table, i want to read only file path and check file path which filetype like .xls or .xml and then import to excel source and to db destination , the same via for all file type

    4. next read data from resources import correct data into correct table and wrong data into error table

    5.for all these above condition are in loop.

    pls give a example for this its very urgent

    pls pls help me out for this

  • September 2, 2010 at 7:13 am

    #1215575

    Do all files of the same type have the same record structure? This is important because it will determine a single Data Flow can be defined to handle all files of the same type, or if you will require multiple data flows for different file layouts.

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

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