SQL Server Performance

informix

Discussion in 'SQL Server DTS-Related Questions' started by albert85, Mar 1, 2006.

  1. albert85 New Member

    i want to retrieve the informix data and put it into a text file. how i going to do this???
  2. FrankKalis Moderator

  3. satya Moderator

  4. mmarovic Active Member

    You can also use informix unload sql statetment. Google on informix unleashed keywords.
  5. albert85 New Member

    what i going to do is retrieve the informix data and put inside the text file. then the MySQL database will get the data from the text file and save it. how to do this whole process
  6. mmarovic Active Member

    So it does not have anything to do with microsoft sql server, this site is about. For informix side, you can use informix unload sql statement to generate pipe delimited text file. I have no idea how to import such file into mySQL database, better ask that question on mySQL dedicated forum.
  7. FrankKalis Moderator

    Assuming that MySQL is a typo, you might want to check<a target="_blank" href=http://www.sqldts.com>http://www.sqldts.com</a> as a good resource for DTS questions. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterst�tze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)

Share This Page