Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I pull data from multi Legacy SQLAnywhere (~v5.5) into SSIS or SQL Server

2 posts in General Discussion Last posting was on 2007-08-29 23:21:39.0Z
Walter Levine Posted on 2007-08-28 17:59:38.0Z
Sender: 6d85.46d412e2.1804289383@sybase.com
From: Walter Levine
Newsgroups: ianywhere.public.general
Subject: How do I pull data from multi Legacy SQLAnywhere (~v5.5) into SSIS or SQL Server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <46d4628a.7685.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Aug 2007 10:59:38 -0700
X-Trace: forums-1-dub 1188323978 10.22.241.41 (28 Aug 2007 10:59:38 -0700)
X-Original-Trace: 28 Aug 2007 10:59:38 -0700, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6253
Article PK: 4675

My local machine is running SQLAnywhere v10.
I am using SSIS to pull data from remote systems into SQL
Server
I need to pull from a number of v5.5 machines
I think I could use ODBC if there is an ODBC driver for v5.5
for my Windows Server 2003 box
Thanks for any help
Walter


"Nick Elson" < Posted on 2007-08-29 23:21:39.0Z
From: "Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@>
Newsgroups: ianywhere.public.general
References: <46d4628a.7685.1681692777@sybase.com>
Subject: Re: How do I pull data from multi Legacy SQLAnywhere (~v5.5) into SSIS or SQL Server
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: nicelson-d620.sybase.com
X-Original-NNTP-Posting-Host: nicelson-d620.sybase.com
Message-ID: <46d5ff83$1@forums-1-dub>
Date: 29 Aug 2007 16:21:39 -0700
X-Trace: forums-1-dub 1188429699 10.25.98.247 (29 Aug 2007 16:21:39 -0700)
X-Original-Trace: 29 Aug 2007 16:21:39 -0700, nicelson-d620.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6268
Article PK: 4681

The media the legacy servers were installed from
also have the ODBC drivers on them. Just do
a Network Client install from those and the ODBC
drive and required gear should come. Make sure
to apply the latest 5.5.05 maintenance release and
last ebf since 5.5.0.5 went EOL Y2K.

Referencing this 'Archived Versions' document list
support up to Windows 2000 and XP with EBF#
2816.

But there was never any official support for Win2003.



EBFs can be download from
http://downloads.sybase.com/swd/base.do?client=support

<Walter Levine> wrote in message news:46d4628a.7685.1681692777@sybase.com...
> My local machine is running SQLAnywhere v10.
> I am using SSIS to pull data from remote systems into SQL
> Server
> I need to pull from a number of v5.5 machines
> I think I could use ODBC if there is an ODBC driver for v5.5
> for my Windows Server 2003 box
> Thanks for any help
> Walter