All,
I need to move PROD data into DEV & QA on every night. There are around 8 tables which i need to move.
Each of them have around 600000 records.
I used sybase OC to move data to DEV & QA.
I used 'clear table then insert rows' option, it is nothing but, 'Truncate and then insert' which will fill the transaction log. It also took around 1 hr to complete the execution.
So i have been asked to use sybase BCP stage. Since i am not aware of this stage, i got struck to use this.
I created the job as below.
sybase OC---> Tranformer --> sybase BCP
Prod server ---------------------> DEV server
when i execute the above job,
BCP..Sybase_BCP_Load_1: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
BCP..Sybase_BCP_Load_1: Login failed
Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
i got the above error messages
Sybase BULK COPY
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Sybase BULK COPY
Karthik
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Re: Sybase BULK COPY
After i changed the client library from MSDBLIB to SYBDBLIB
i got the below error message.
BCP..Sybase_BCP_Load_1: Bulk copy failed. Client does not have the capability to bulk copy into the data-only locked table 'acs..Perf'.
i got the below error message.
BCP..Sybase_BCP_Load_1: Bulk copy failed. Client does not have the capability to bulk copy into the data-only locked table 'acs..Perf'.
Karthik
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
Re: Sybase BULK COPY
I changed it to SYBCTLIB. It is working fine now.
how to clear the table before running the job?
will it be done automatically?
or do we have to call any stored procedure internally?
how to clear the table before running the job?
will it be done automatically?
or do we have to call any stored procedure internally?
Karthik
-
- Premium Member
- Posts: 729
- Joined: Tue Apr 28, 2009 10:49 pm
I have created one more job to clear the table and then i ran this job.chulett wrote:I have no knowledge of this stage, but if you can't find an explicit 'clear/truncate' option for it, you could always use your original job concept to do that using an empty source and then running your new job.
Karthik