"TomT" <tomt@newsgroup.nospam> wrote in message
news:F897423D-00AC-4E68-8DF3-4C8F6F80A970@microsoft.com...
> We have a number of DTS packages running on a SQL 2000 server, pulling
> data
> from a non-relational accounting database.
>
> The package is set up using an ODBC connection to this database, which
> uses
> a system dsn on the machine.
>
> I want to re-create all this over on a SQL 2005 system. I have installed
> the
> ODBC driver which allows me to create the dsn, which tests successfully. I
> am
> creating a new SSIS package to try this out, but am a bit stumped. I've
> created a data source based on the dsn, which appears to work fine (and
> appears in the connection managers), however I'm at a loss as to how to go
> from here. I have been trying to create a data flow task to access the
> accounting data, but the choices don't include (as far as I can see) and
> ODBC
> connection, just OLE DB, which does not let me use the connection I set
> up.
>
> I would have thought there would be and ODBC data flow source? In 2000, I
> used a transform data task, but so far have not found it's equivalent in
> 2005. I'm sure I'm missing something obvious (I hope) - I'm just looking
> for
> a way to use the odbc connection in a data flow task.
>
> At this point, I don't want to just import the previous dts packages, as
> I'd
> like to completely re-do them.
>
> Any help would be most appreciated,
>
> Thanks,
>
> Tomt