May 17, 2010 at 1:25 pm
Hello all,
Has anyone ever worked with .adt (I believe they are advantage database) files? I needed to load this file type into a SQL database with SSIS but I'm trying to figure out the first step which is defining a data source for this file type. Once I can figure out who to define this as a data source, loading it into the database shouldn't be a problem.
Thanks,
Strick
May 18, 2010 at 11:36 am
If these are Sybase Advantage DB files then maybe this link will help you:
http://www.sybase.com/products/databasemanagement/advantagedatabaseserver/odbc-driver
You would install this on your dev machine as well as the SSIS server and set up a DSN.
May 18, 2010 at 1:35 pm
Hi,
Actually found that they have a Advantage .NET Data Provider which looks to be more efficient at reading the data than the older odbc technology. It works really well and maps to the datareader source task in ssis 2005 (ado.net source task in ssis 2008).
Thanks,
Strick
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply