Still duplicates.

My requirement is to check if single ID has 2 rows in A table and if Name is ('AUSN','MAN') and code will be different for AUSN and MAN.

if that's...

I am getting this error

Msg 4104, Level 16, State 1, Line 31

The multi-part identifier "updated.Id" could not be bound.

Msg 4104, Level 16, State 1, Line 31

The multi-part identifier "updated.Date" could...

Is this correct?

DECLARE @tableVar TABLE (MergeAction VARCHAR(20), InsertedId NVARCHAR(50), UpdatedId NVARCHAR(50),InsertedDate date, UpdatedDate date)

MERGE dbo.Student as Target

USING temp.student as Source

ON  Target.Id = Source.Id

AND Target.Date = Source.Date

WHEN MATCHED AND (ISNULL(Target.StudentLocation,'') <>...

ty, it worked

tried, giving invalid token errors

It didn't worked. I have an excel template where i copy the format from source to destination, once data loaded into the destination file, i am renaming it with file...

i have a string variable where it holds the datetime stamp value. using the same in move too.

in between rename and move file system task. i have created dummy script...

May i know the reason why i get this error The data types varchar and datetime2 are incompatible in the add operator. when i changed variable from date time to...

SET @CaptureError= @CaptureError + ' ,Date: ' + convert(varchar(10), @Date,101)

Is this correct?

Its kind of dump ; yeah . how can we merge it?

its requirement.

any one has sample script task to do this?

so i need to select row delimeter as vertical bar {|} ?

My Row Delimeter is {CR}{LF}

Format - Delimited

Text Qualifier as None

Header RowDelimeter - {CR}{LF}

Header rows to skip 0

columns names in the first data row box is unchecked.

problem is each select statement is coming from different tables. first select statement is form student table, second one is form studentbook and 3rd is from studentarchive.

all tables has different...