RE: Connecting to Sybase

Have you tried pushing the data directly into AS using SSIS, without staging
it in SQL Server? This paper describes push mode processing in more detail:
http://msdn2.microsoft.com/en-us/library/ms345142.aspx

No idea about your problem with type conversions, though. Probably someone
on the SSIS newsgroup might be able to help there.

Chris
--
Chris Webb, MVP
Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk
Blog: http://cwebbbi.spaces.live.com/


"Marty" wrote:

What about just getting it to connect the the database engine? I have no
issue with pulling the data from Sybase on a daily basis and putting it into
a Sql server table then having ssas get the data from there.
--
Marty


"Chris Webb" wrote:

Hi Marty,

AS2005 doesn't support ODBC connections any more unfortunately. It's been a
while since I've worked with Sybase as a datasource for AS, but I did speak
to someone who had been successful using it with AS2005 a few months ago.
They were using the Sybase OLEDB Provider and then had to create a new
cartridge file to ensure that the correct SQL was being generated for
processing (look under %Installation Location%\OLAP\bin\Cartridges to see
what cartridges look like). Sybase isn't an officially supported data source
but it should be possible to get it to work with a bit of effort...

Regards,

Chris

--
Chris Webb, MVP
Analysis Services and MDX Consultancy: http://www.crossjoin.co.uk
Blog: http://cwebbbi.spaces.live.com/


"Marty" wrote:

I am having an issue with trying to connect to Sybase (ODBC). I have come
across somethings on the net that say that you can't do it with Analysis
Services 2005. Is this true? If it is, Is there a work around this? I can
Link to Sybase with Access and get to the table I need but when I try to use
SSIS 2005 to import the data into sql server 2005 I have a date conversion
issue with dt_date and dt_dbTimestamp. I would think there should be an
easier way for me to get this data from Sybase to Sql server 2005 instead of
trying to go through Access. I am sorry if there is an obvious answer to
this. I have never worked with Sybase and we usually don't require the need
to connect Sql server to other type of Databases so connecting to other
systems is new to me.

Thanks for the help,
--
Marty
.

Relevant Pages

  • Re: Migrating SQLServer DBs to Sybase
    ... Server-generated scripts to create the structure in Sybase, and SQL Server ... AseConnection objCon = new AseConnection; ... objCon.ConnectionString = strConnectionString; ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Scheduling DTS job
    ... If you try to transfer the same rowsfrom SQL Server to SQL Server ... > How do i see if there is any difference in the driver ... >>> The SQL server agent is running as Local System Account. ... >>> Nothing has been changed in sybase box. ...
    (microsoft.public.sqlserver.dts)
  • RE: Numeric Overflow of Column of datatype Money
    ... Sybase driver is failing on the column, long before it reaches SQL Server. ... That I have serveral column with datatype money that didnt have the ...
    (microsoft.public.sqlserver.dts)
  • Re: MS SQL server & Sybase interoperability
    ... > I have an application build on Sybase database, and we waant to install MS ... We are using Sybase ASA and SQL Server 2000 on the same machine. ... Installing SQL Server 2000 AFTER installing Sybase did not cause ... caused problems with the ODBC dlls. ...
    (microsoft.public.sqlserver.server)
  • Re: Sybase Connectivity
    ... I am trying to connect to Sybase to get the data in SQL Server 2005. ... SSIS 2005 to import the data into sql server 2005, ... I need immidate help. ...
    (microsoft.public.sqlserver.connect)