December 14, 2004 at 11:46 am
do you know if it can pull data from the mainframe, say an ADABAS file and store it into a SQL Server table using the New Integration Services. If so, is there some examples some where?
Arthur Lorenzini
December 15, 2004 at 2:57 am
Hi Arthur,
This will depend on whether there is an OLE DB Provider for your data source. Not knowing anything about mainframes I'm not the person to ask about this.
Alternatively, if the source is a flat file, you could try an SSIS data source adapter called the "Flat File Source" which allows you to access flat files (unsurprisingly).
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
December 15, 2004 at 10:20 am
SQL2005 IS should be able to pull data from any ODBC compliant data source.
If you can find an ADABAS ODBC driver for Windows, then IS can get your data. (ADABAS should be able to provide such a driver.)
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply