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 |
|
jimruddy
Starting Member
4 Posts |
 Posted - 2008-06-17 : 09:37:51
|
| What destination task do I use from the toolbox that will connect me to AS/400 database through an ODBC? Each one that I try doesn't do it.Jim |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-17 : 09:45:37
|
quote:
Originally posted by jimruddy
What destination task do I use from the toolbox that will connect me to AS/400 database through an ODBC? Each one that I try doesn't do it.Jim
Explain What are you trying to do? |
 |
|
|
jimruddy
Starting Member
4 Posts |
Posted - 2008-06-17 : 11:40:13
|
| I am trying to move data from a table in a SQL Server database (connected by OLEDB) on our Development SQL Server to a database residing on a Development AS/400 (connected by an ODBC connection). I can connect therough Access to the AS/400 table to monitor whether the data is getting there or not. What I need to do, task-wise in the package, is clear out the AS/400 database, and move the data from the SQL Server to the AS/400 nightly in an SSIS package. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 22:26:38
|
| Did you install client access on dev sql server? |
|
|
|
|
|
|
SSIS Export from SQL Server to AS/400