SSIS- Excel Source

  • Hi,

    i need your help please! , i'm new to sql server and i have about 30 excel files to extract,

    the files have different formats and differents types of data.

    is there a way to extract them all at once or do i have to deal with each file individually with an Excel connection manager per each ????

    thank you in advance,

  • You will have to deal with each one individually.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • ok. thank you for your reply 🙂

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

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