Post reply

Import Excel data to a SQL database dynamically

  • October 15, 2008 at 1:37 pm

    #194660

    Hello, the scenario is as follows for SSIS: I need to dynamically build connection string to the source Excel file, the xls file name, the name of the sheet, the connection string of sql destination (server, user, pass), the name of the table and db, for Integration Services SSIS, the data excuse my English

    Tk

    Emerson Aguilar

  • October 17, 2008 at 12:14 pm

    #886567

    In BIDS under connection managers, highlight the connection and go to the properties page for that connection. Use the expressions editor to build an expression for the connection. For more help w/ expressions search the SSIS forum or check out http://www.sqlis.com

    Tommy

    Follow @sqlscribe

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

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