HI I have one migration project from 8.1 version to 8.5 Version. In that project one to the job is used to trigger Sp from SQL Server 2005. It was woring fine in the 8.1 version and DB as well. The purpose of the SP is to populate the staging area data to target tables. The target tables are having the primary and foriegn key constraints while the staging area is not. In 8.5 it is not woring and throwing the error as :
Conversion failed when converting character string to smalldatetime data type., Error Procedure: ETLClm, Error Line: 118. Please help me .. how to resolve this..
I tried both in server and parallel jobs in 8.5 still getting the error where as the same code is working fine in 8.1 version.
Error while running SP in 8.5 version
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Fri Oct 22, 2010 7:08 am
Error while running SP in 8.5 version
Thanks & Regards,
Bhanu
Bhanu
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
Which stored procedure is this...source,target or transform.
Which stored procedure is this...source,target or transform.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 23
- Joined: Fri Oct 22, 2010 7:08 am
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Try to manully run the procedure and check if it is working fine.I thing your procedure is failing due to data type issue.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/