Re: Sybase Source. What "data flow source" to use?

Is there not a Sybase OLE DB Driver?

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"JJ of Eugene OR" <JJwithQuestions@xxxxxxxxxxxxxxxxx> wrote in message
news:6A80D2D0-5EB5-4D0A-880C-FFB608EC2C51@xxxxxxxxxxxxxxxx
Allan,

Thank you very much! One of those should work once I figure them out.

However: both options seem very complicated to me, especially compared to
DTS. I've been so excited about SSIS and telling my co-workers how
superior
I think it is while they have been bemoaning the loss of DTS. Now, I'm
pretty disappointed in SSIS, because I think of DTS/SSIS as a basic tool
for
getting data from one source to another. And being able to connect easily
to
Sybase seems like a no-brainer need to me. It is also a task that I have
to
do all the time. I'm familiar with VBA, but not vb.net, so aside from all
the typing (I have a LOT of tables and DTS packages to do this to), I will
have yet one more learning curve besides SSIS and SQL Server 2005.

The point: Does anyone know of another, easier solution in SSIS than
writing .NET code by hand or figuring out the data reader? Or am I out of
luck? If there is no solution now, is there any hope of a better way
coming
out in a future version of SSIS? Perhaps I should delay upgrading to SQL
Server 2005 given how many data transfers I have to do?? I'm not being
lazy,
I just have a huge amount of work an no time to do it. I have to be
practical.

Thanks,
- JJ, Eugene OR


"Allan Mitchell" wrote:

You could use the DataReader source or you could flip this article around
and do it in a Script Component

http://msdn2.microsoft.com/en-us/library/ms345157(SQL.90).aspx

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"JJ of Eugene OR" <JJwithQuestions@xxxxxxxxxxxxxxxxx> wrote in message
news:45A8E249-B1AB-4B0E-B80E-7FD081AC422A@xxxxxxxxxxxxxxxx
I am trying to manually re-create a DTS package in SSIS. The data
source
is
a Sybase database (not in my control) and the destination is my own
lovely
SQL Server 2005 database. I can't figure out how to add a data flow
source
object/task/icon that will connect me to the Sybase data.

I added an ODBC connection manager that works great when I do an
'execute
SQL task' on the 'Control Flow' tab. For example, I am able to do a
simple
query of the Sybase database in the 'Execute SQL Task'. This query
works
and
populates a package variable with the return result of the query. So,
I
know
that the connection is valid and and I'm even able to get the ODBC
connection
manager to work in the Control Flow tab.

The Problem: Then I add a 'data flow task' and go to the Data Flow tab.
My
goal is to do a query of the Sybase database and copy that data into my
destination. When I look at source options, I see OLE DB, Flat File,
etc.,
but no ODBC. I tried to configure some of the other sources to work
with
an
ODBC source, but I couldn't figure out how to do it. For example, I
remembered a long time ago seeing something to the effect that OLE DB
had
an
ODBC option, but I'm not seeing anything like that in the options for
configuring a new OLE DB connection manager.

I bought the SSIS book and went over quite a bit of it, but it didn't
answer
this question. I know how to import from flat files, etc., but not an
ODBC
database. Also, I researched this discussion group and can see that
this
is
a very basic question which others have already figured out. There is
another post where someone is beyond the point where I'm at. But I'm
stumped
at this point. Any help would be most appreciated.

Thank you,
- JJ, Eugene OR





.

Relevant Pages

  • Re: Sybase Output into Excel
    ... I have run queries against Sybase many times, single tables, multiple ... OLE DB providers not ODBC, ...
    (microsoft.public.excel)
  • Re: Sybase Source. What "data flow source" to use?
    ... There is currently no listing of a Sybase OLE DB Driver in the drop down ... added a Data Reader Source to the data flow tab ... query of the Sybase database in the 'Execute SQL Task'. ...
    (microsoft.public.sqlserver.dts)
  • RE: ODBC Error with Sybase from Win2K Server (but works from WinXP!)
    ... I'd like to know if you create a DSN in odbc ... When configuring the DSN for the ODBC connection to Sybase, ... SQL Server connection. ... >> HOWEVER, exeute the same stored proc on my workstation (WinXP Pro SP1, ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL Server--> Sybase linked server
    ... Can you create an ODBC data source connecting to Sybase? ... > drivers not installed with ASE or how can i get the ...
    (microsoft.public.sqlserver.server)
  • Re: Getting external data ODBC connect errors when connecting with Access
    ... You probably have better luck getting solution from Sybase newsgroup. ... Don't have a problem with ODBC with Excel works fine but I run into ... > layer:internal net library error: Net-Lib protocol driver call to connect ...
    (microsoft.public.sqlserver.programming)