Post reply

lookup between two text file

  • December 30, 2008 at 11:57 am

    #127759

    Hi there,

    Is it possible to lookup between two text file without importing data in database table? I read somewhere that it is possible by using openrow set but someone can explain in more detail?

    Thanks!!

  • December 30, 2008 at 3:04 pm

    #919336

    There is no Openrowset Connection in SSIS.

    You should be able to use an openrowset within an execute sql task

    OpenRowset described in books Online

    http://msdn.microsoft.com/en-us/library/ms190312(SQL.90).aspx

    What exactly are you trying to do?

    Post examples of your files, and what your looking to solve and I'm sure someone could help

  • December 31, 2008 at 10:38 am

    #919752

    Thanks Ray!

    Yeah I used openrowset in sql and it works. At the moment I have fixed number and name of columns so using predefined format file but still trying to find if anyway possible to create automatically .fmt file.

    Thanks again!

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

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