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 - 2000-11-21 : 22:31:09
|
Phil writes "Help urgently needed.
I have a client who has setup a DTS package to import data from an AS400. To facilitate this he has created a DSN to point to the AS400.
He wants to be able to use a different table name each time rather than the one he specified in DTS.
Question a) can this be achieved simply.
Question b) would an alternative be to set up the AS400 as a linked server and Select Into from there with an editable script ? If so what would the syntax be as the only examples I can find use OLE-DB and he is using ODBC for his DSN.
Question c) any chance of an answer today as I will be on-site tomorrow (yes Sunday !) and want to be able to offer a solution.
I am a VB developer rather than a SQL Database administrator, hense the question.
Many thanks in anticipation." |
|
|
|
|
|
SQL Server 7.0 Importing from AS400