Equivalant Exception for DUP_VAL_ON_INDEX for SQL Server

Hello,
We are in the process of migrating the Oracle database to SQL Server. We need the help on the Exception Handling in SQL Server.
The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDEX, which raises when the duplicate values gets inserted in the Indexed column. (typcially used with INSERT statement)
We need the equivalant statement for the exception mentioned above.
I request you to elp us out in this case.
Thanking in advance.
Duplicates for a unique index insert return the error number
is 2601. The error message depends on the object name but
it's:
Cannot insert duplicate key row in object '%.*ls' with
unique index '%.*ls'.
-Sue
On Wed, 31 Mar 2004 03:21:06 -0800, Aparna
<aparna.shirodkar@.lycos.com> wrote:

>Hello,
>We are in the process of migrating the Oracle database to SQL Server. We need the help on the Exception Handling in SQL Server.
>The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDEX, which raises when the duplicate values gets inserted in the Indexed column. (typcially used with INSERT statement)
>We need the equivalant statement for the exception mentioned above.
>I request you to elp us out in this case.
>Thanking in advance.
|||Hello Sue,
Good Morning. Thank you very much for the very useful help. Yesterday late evening i tried the same and was at the conclusion of the error no. 2601 as the equivalant in SQL.
Your ans. supports that and i an confirmed now.
Thank you once again.

Equivalant Exception for DUP_VAL_ON_INDEX for SQL Server

Hello,
We are in the process of migrating the Oracle database to SQL Server. We nee
d the help on the Exception Handling in SQL Server.
The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDEX
, which raises when the duplicate values gets inserted in the Indexed column
. (typcially used with INSERT statement)
We need the equivalant statement for the exception mentioned above.
I request you to elp us out in this case.
Thanking in advance.Duplicates for a unique index insert return the error number
is 2601. The error message depends on the object name but
it's:
Cannot insert duplicate key row in object '%.*ls' with
unique index '%.*ls'.
-Sue
On Wed, 31 Mar 2004 03:21:06 -0800, Aparna
<aparna.shirodkar@.lycos.com> wrote:

>Hello,
>We are in the process of migrating the Oracle database to SQL Server. We ne
ed the help on the Exception Handling in SQL Server.
>The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDE
X, which raises when the duplicate values gets inserted in the Indexed colum
n. (typcially used with INSERT statement)
>We need the equivalant statement for the exception mentioned above.
>I request you to elp us out in this case.
>Thanking in advance.|||Hello Sue,
Good Morning. Thank you very much for the very useful help. Yesterday late e
vening i tried the same and was at the conclusion of the error no. 2601 as t
he equivalant in SQL.
Your ans. supports that and i an confirmed now.
Thank you once again.

Enterprise Manager (Import Data) - DTS Error

I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data source
. I select the destination. I select 'Copy table(s) and view(s) from source database." I select all tables. I select the 'run immediatedly' option. When I click the 'Finish' button, I receive the following message in a message box entitled 'Initializ
e Com:"
Could not create an instance of the DTS Package.
Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.
Problem solved. I installed SP3a and import/export works fine now.
"Ross Russell" wrote:

> I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data sour
ce. I select the destination. I select 'Copy table(s) and view(s) from source database." I select all tables. I select the 'run immediatedly' option. When I click the 'Finish' button, I receive the following message in a message box entitled 'Initial
ize Com:"
> Could not create an instance of the DTS Package.
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.

Enterprise Manager (Import Data) - DTS Error

I created a new database in Enterprise Manager and then attempted to import
data into this new database from an existing database via the "import data"
option. This launches the Data Transformation Services Import/Export Wizard
. I select the data source
. I select the destination. I select 'Copy table(s) and view(s) from sourc
e database." I select all tables. I select the 'run immediatedly' option.
When I click the 'Finish' button, I receive the following message in a mess
age box entitled 'Initializ
e Com:"
Could not create an instance of the DTS Package.
Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.Problem solved. I installed SP3a and import/export works fine now.
"Ross Russell" wrote:

> I created a new database in Enterprise Manager and then attempted to import data i
nto this new database from an existing database via the "import data" option. This
launches the Data Transformation Services Import/Export Wizard. I select the data s
our
ce. I select the destination. I select 'Copy table(s) and view(s) from sou
rce database." I select all tables. I select the 'run immediatedly' option
. When I click the 'Finish' button, I receive the following message in a me
ssage box entitled 'Initial
ize Com:"
> Could not create an instance of the DTS Package.
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.