Great! - Thank you for the feedback.

skt5000 (2/11/2010)

---

I believe this might help you

declare @date datetime

set @date = '01/08/2010'

SELECT DATEPART(day,@date),DATEPART(weekday,@date)

SELECT CASE

WHEN DATEPART(weekday,@date) = 2

...

You may find this article interesting.

Allen,

there's nothing wrong...

There's a lot to say and write about this. Which one is best for you largely depends on how you are going to use it. So you may want to...

You may find this article on dynamic SQL and when (not) to use it interesting.

Gail certainly has a point there.

But to answer your question: SQL Server thinks EmployeeID is a column from a table, but you don't tell it which table it shoud come...

Great! Thank you for your feedback.

Try Linked Measure Groups.

I assume you are using the Transfer SQL Server Objects Task.

I was hoping that you could ignore the error by raising the MaximumErrorCount property of the Task, but this...

Maybe this[/url] can be of help.

I agree with the suggestions made above.

The way I solve it goes like this:

DECLARE @sp_executesql NVARCHAR(150) = QUOTENAME('name of your database goes here') + '.sys.sp_executesql' ;

I put...

Use a merge statement.

To get data from the remote server you can use either SSIS or a linked server.

Which driver are you using for reading from Oracle and what is the version number of the DB?

Yep.

You can also do this, but be aware that you will lose all text entered after the 60th character.

UPDATE t

SET NOTES2 = LEFT(s.NOTES1,60)

FROM ...