Thank you for clarifying so that is called composite key right?

Thanks for the prompt response.

So, if I try to insert the below , it executes:

Is it because it is composite key that col V is able to have duplicate values?

INSERT...

Here's the one that I test out:

CREATE TABLE [dbo].[C](

[V] [varchar](12) NOT NULL,

[CT] [varchar](2) NOT NULL,

[CE] [real] NULL,

[CL] [real] NULL,

[CX1] [real] NULL,

CONSTRAINT [C$C2] PRIMARY KEY CLUSTERED

(

[V] ASC,

[CT] ASC

)WITH (PAD_INDEX...

Got the error on subscriber.

This is the error message:

DESCRIPTION:Replication-Replication Distribution Subsystem: agent A failed. Offset 455 is not in the range of available LOB data.

Thanks for the correction

Thank you.

But is also picking for included columns, I want to exclude that one

I have one column:

SLVER CREEK DR

3RD ST

S OAK GATE LN

ABCSDGFDG LN

Turtle WnhhkjT

E Royal Street

Values that need to be in

ColA : S,E

ColB : SILVER CREEK, 3rd, OAK GATE,ABCSDGFDG ,Turtle...

Thank you for the reply.

My requirement changed a bit:

I have one column:

SLVER CREEK DR

3RD ST

S OAK GATE LN

ABCSDGFDG LN

Turtle WnhhkjT

I need the above data split into three columns:

ColA ...

Thanks for the prompt reply.

Actually my data is as below in one column:

SLVER CREEK DR

3RD ST

OAK GATE LN

ABCSDGFDG LN

WnhhkjT ST

I need to split the above data into two columns

1st Column...

Package is deployed in ssisdB in one server(Server A)

I need a stored proc to execute that package. Stored Proc will be in different server(Server B)

So SP in Server B...

I am using UNC path, could it be Kerberos issue?

SSIS in one server, job in another and UNC path is different

How do we do using OLEDB?

For Linked Server, do we need to install Oracle client in the server which is running SQL?

SSIS package runs from when I execute it manually or from VS. But it fails from the agent with the truncation error.

What could be the issue?

Thanks but how would it spread data from the 1st file which is 2 TB to second file created?

Thank you