Migrate data to Sybase

[psamedy]

I'd like to import data (weekly) into some sybase data from a csv file(it be generated by from a SQL Server database).

What are my options?

Thanks Pat

 

[psamedy]

Sorry for the confusion:

What I meant was, I need to migrate SQL server Data into a SYBASE table on a weekly schedule:

What is the best way to do this.

Thanks

 

[mjuell]

Use ISQL in a unix script, and put the script into a crontab job.

Thats what I would have done!.

 

[mjuell]

I mean use BCP, to bcp the file into the table.

 

[billdvldog]

Pat,

If you have SQL Server, I would use DTS. Create the job and schedule it for once a week.

Bill

 

[indywizard]

The DTS Does not work if you have to insert data into a table with a identity field. Seems the sybase OLEDB driver is incomplete