Home Forums SQL Server 2005 SQL Server 2005 Integration Services IS it possible to have dynamic sql in ole db src where the table is the part that is dynamic? RE: IS it possible to have dynamic sql in ole db src where the table is the part that is dynamic?

  • October 23, 2012 at 12:35 am

    #1551735

    No. SSIS can't handle the changing metadata.

    Maybe using the Import/Export wizard can be an option?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP