It is a standard ODBC connection to a system DSN. Surely SSIS allows you to connect to an ODBC data source?! If not, I am sunk. Even Crystal Reports can...

1) Under Server Explorer in Visual Studio I can open the DSN that connects to my source Btrieve database (It is not a SQL Server 2005 database). I can see...

You have no idea how much I appreciate your help!

I wish I were extracting from a SQL Server database. I really don't know much about the legacy database that I...

Thanks for the replies. I just started reading BOL today. My boss has unrealistic expectations. I need to extract data from a Pervasive SQL database, transform it and use it...