Re: Sybase Source. What "data flow source" to use?
- From: NEXDEV <NEXDEV@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 17 May 2006 19:28:01 -0700
Thanks for the reply. This is the first time I've used a newsgroup, so I'm
probably missing it, but I can't find an "attached graphic".
--
NEXDEV
"Allan Mitchell" wrote:
Hello NEXDEV.
Does the attach graphic work for you?
Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com
Allan, I have a similar problem and I think JJ expressed very well the
frustration some of us are feeling. With SQLServer 2000, I and
several others, used DTS to transfer data from ODBC datasources
defined on our computers into SQL Databases. One in particular that I
can no longer do is Centura SQLBase, used by ADP Payroll. I'm sure it
can be done by creating a script, but I work with people who are not
programmmers, but could still use DTS to move data. To restate the
problem, when I right-click over a SQL 2005 database and select Import
Data, the list of providers does not include either A) the list of
datasources defined in ODBC Datasources on my computer, or B) an OLEDB
Provider For ODBC that I have seen before. In a nutshell, I want to
be able to transfer data from datasources in ODBC into SQL server. I
want to be able to do it through the point and click interface such as
existed in DTS. Is this at all possible?
"Allan Mitchell" wrote:
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
- Follow-Ups:
- Re: Sybase Source. What "data flow source" to use?
- From: Allan Mitchell
- Re: Sybase Source. What "data flow source" to use?
- References:
- Re: Sybase Source. What "data flow source" to use?
- From: NEXDEV
- Re: Sybase Source. What "data flow source" to use?
- From: Allan Mitchell
- Re: Sybase Source. What "data flow source" to use?
- Prev by Date: Re: Scheduled Package Results Contradictory
- Next by Date: Re: Sybase Source. What "data flow source" to use?
- Previous by thread: Re: Sybase Source. What "data flow source" to use?
- Next by thread: Re: Sybase Source. What "data flow source" to use?
- Index(es):
Relevant Pages
|
