error with connection string

[tirf]

I am trying to extract data from interbase database through SSIS package; when trying to connect to the database it is failing.

here is the message ( I am using the LCPI OLE DB provider)

Test connection failed because of an error in initializing provider. Database connection failed.
Unable to complete network request to host "Local Server gds_db".
Failed to locate host machine.

Thanks

 

[NoCoolHandle]

so what does the connection string look like?

 

[tirf]

I was able to fix this issue; it was a file path issue.

I have one more question though, I am trying to import more than 50 tables from interbase database to sql server using SSIS;

Do i have to create 1 data flow task for eack table that means 50 data flow tasks OR is there an easy way to acheive this in one shot

Thanks,