: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?