Post reply

Excel to DTS to Informix and Run Informix SP?

  • May 8, 2006 at 10:51 pm

    #67432

    I have a task to update some Peoplesoft tables (Informix) with data from an Excel Spreadsheet.

    My Plan:

    1) bring data in from Excel to SQL Server Table.

    2) Create DSN for Informix

    3) Use DTS to copy data from SQL Server Table to Informix Table

    From reading this forum, I think that is workable.

    But how do I use DTS to execute an Informix stored procedure?

     

    Thanks,

    Tony

     

    Things will work out.  Get back up, change some parameters and recode.

  • May 10, 2006 at 6:11 am

    #636974

    When you create your DTS job, use an Execute SQL Task.  Choose the proper Connection (the one to your informix dsn) and call your sp the same way you would if you were calling it from the informix client tools.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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