I'm running this manually. Not using the sql server agent.

To the OP. Where you able to complete your sybase migration to SQL 2005?

I have the same requirements and I wonder how you handled the stored procedures and UDFs?

What were...

Just wonder how he found this solution?

I'm facing the same issue. Anyone knows the answer?

how did this end up? I'm curious?

How did your project end up? I will be interested to know. Thanks.

I like to know some answers to this questions as well.

Mr. Jeff,

Yes, the 40 tables have different columns but they all have the same createdate and changedate columns which helps for the incremental extract.

The format has to be pipe delimited...

I BCP THE tables out + data. Now how can I do incremtanl extract like using changeDate = Yesterday?

Thats insane I have 1000 tables. IT would take me an eternity to finish 1000 tables. So foreach loop wont do it? remember i also have to rename the txt...

can I use ssis to extract all the tables including data and put them into a multiple txt files using their respective names? its a incremental extract. DAta from yesterday...

THANK YOU FRANK

No, it is not. cause i created a new folder and shared it. Went to DOS and try to open it like cd [new...

Just fixed the issue. Upgraded to SP2 and it solved the issue.

Nowadays interviewers are looking for DBA who can do everything such as:

sql server 2k, 2k5, replication (3 types), backups (3 types), disaster recovery, cluster server, SSIS, SSAS, SSIS, DTS, data...