Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-05 : 08:00:33
|
| Quinton writes "Is there any way to have SQL Server 7 pull information directly from and IBM MQSeries queue?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-05 : 08:34:16
|
| First, I don't know ANYTHING about the IBM MQSeries queue. However, SQL Server can link to, or import from, any data source that can be accessed using OLE DB or ODBC providers. There are some limitations, but generally this is true. If there is no OLE DB or ODBC provider for MQSeries, you would need to write a custom application that can access its information. Then you can use it as part of a DTS package to import the data into SQL Server. Be aware that this will very likely be very very slow.Can you export the IBM data into a text file of some kind? SQL Server can then use DTS, BULK INSERT, or bcp to import the data into SQL Server. Take a look in SQL Server Books Online for more info on "DTS", "BULK INSERT" and "bcp". |
 |
|
|
|
|
|
SQL Server 7 and MQSeries