June 16, 2008 at 8:31 pm
:unsure:I have need to duplicate a 2000 DTS package in SSIS. I do not have a viable source (that I can see) to setup the source for the Data Flow Task. The data source is a remote server running DBs under a Sybase 11 environment. The data transfer works fine under SQL2000/DTS.
I can successfully setup the Sybase DB in the connection manager, but I cannot build the package using Data Flow Task... for the source, I see EXCEL, DataReader, Flat File, OLE DB (don't see anything friendly behind that!), Raw File and XML.
Can this be done? Where have I gone awry?
June 16, 2008 at 11:59 pm
Hey,
Depends on your Sybase version that you are running.
From previous threads, I understand with later versions you can use OLE DB, where your Sybase driver should appear under the native OLEDB section.
With previous versions, you can use a .NET connection manager with a datareader source.
Someone else had a similar problem not so long ago, maybe this can assist you
http://www.sqlservercentral.com/Forums/Topic516244-148-1.aspx#bm516622
~PD
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply