DTS Package Error

Hello,
I created a DTS package and got the following error:
There is already an object named 'DF_tblTelica_DateEntered' in the database.
could not create constraint. See previous errors.
Is there a table, query or stored procedure that I can use to find this type
of information?
Thanks in advance,
sck10
Hi Sck10,
From your descriptions, I understood that you will meet the error saying
object 'DF_tblTelica_DateEntered' has exists when creating DTS packages.
Have I understood you? Correct me if I was wrong.
Based on my scope, it seems you have created an object named
'DF_tblTelica_DateEntered'. Have you done this? Try to use the following
SELECT statement to find whether it really exists in your database.
SELECT OBJECT_NAME(parent_obj)
FROM sysobjects WHERE name = 'DF_tblTelica_DateEntered'
SELECT *
FROM sysobjects WHERE name = 'DF_tblTelica_DateEntered'
If you do find it, make sure it was useless and then drop it
If you do not find it, please show me you detailed steps about creating
that DTS package. More detailed information, I believe, will make us closer
to the resolution.
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Sck10,
I am just checking on your progress regarding the information that was sent
you! Have you tried the steps I provided to you? I wonder how the testing
is going. If you encounter any difficulty, please do not hesitate to let me
know. Please post here and let me know the status of your issue. Without
your further information, it's very hard for me to continue with the
troubleshooting.
Looking forward to hearing from you soon
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!