You could try starting at Pragmatic Works (www.PragmaticWorks.com) and watching their videos. Brian Knight is an expert at Analysis Services, and his books etc are very easy to follow....

want to select Records from table A and add it or update if exist in table b

Table A

StudentID,StudentName,Age,TotalGrades

Table B

StudentHistoryID,StudentID,StudentName,Age, TotalGrades

select all records from Table A under any condition and insert...

Don't take this wrong, but that's not nearly enough information for anyone to come to any conclusion about what might be going on with your database. What does your...

I said that to maintain the insert order of the records, he needed an Identity column. Looked like he didn't believe me.

Hector,

very true.

Horse, water.

Water, horse.

Jeff,

I thought I said that... maybe he didn't believe me. :hehe:

(Believe me now?)

Is this a homework assignment?

WHERE SomeColumn IS NULL

OR SomeColumn IN (1,2);

is how I would do it, but then I never tried putting NULL in a list as if it...

If you cannot add an IDENTITY (increment) to the destination table, then I do not think it can be done. Data in a table is inherently UNordered, unless you...

Create the table and add the identity column before inserting any records. If you have to create a linked server and create and run an insert to your new...

is there a reason you need to? Just write 3 different queries, one for each table. Or have 3 dataflows in SSIS.

add an incrementing identity column to the destination table before running inserts?

Are you using SQL Server Security or Integrated Security?

What happens if you log into the computer as local admin? If that works, its most likely a security issue in...

Okay, sorry about all the noise. 😀

Problem solved!! Really this time! The map ROCKS!

Here's the update query that worked to fix/populate the Geography data type...

-- you can use...

Mystery SOLVED!!! Here's the cheat code I found:

DECLARE @g geography = geography::STGeomFromText('POINT(' + CAST(@lng as Varchar(50)) + ' ' + CAST(@lat as varchar(50)) + ')', 4326)

which is here:...

use SSIS or bcp. If you play with SSIS at all, you can preview the contents of the text file before running the import.