June 17, 2008 at 8:02 am
I have a OLEDB to a SQL Server as source, and have set up a Connection Manager that connects through ODBC to the AS/400 database. What destination task do I drag and drop from the toolbox that can enable me to set the AS/400 as the destination.
June 17, 2008 at 8:40 am
Oddly enough - there is no ODBC destination adaptor. You will need to use a script component in your data flow. When you drag it out, you will be prompted to decide if it is a source, destination, or transformation. You will have to write some VBA code to put data into the ODBC destination.
June 17, 2008 at 9:21 am
I have no working knowledge of VB. Do you have any suggestions as to where I can find such code readymade?
June 17, 2008 at 9:28 am
Search google for some sample code.
You have some alternatives. You can create a linked server from your SQL Server to the AS400. Also, you are likely to find someone has written an OLEDB Driver for the AS400 that you can buy. If you are going to have the AS400 around for awhile, I would suggest you use one of these approaches.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply