A table script, some sample data and the expected output would help a lot.

Take a look at the article linked in my signature line and find out how to help...

That's not fair, Roy!...

Grant Fritchey (6/8/2011)

Jim Murphy (6/8/2011)

I'm not much of a runner. Uh, at all. But with all of...

I think it's just a display issue, then.

Try this:

-- Source table with some sample values

DECLARE @source TABLE (

id int, -- to...

GilaMonster (6/8/2011)

Fal (6/8/2011)

Didn't mean to imply you didn't, if it came across as such. Was alluding that the second half would be a wholly contained subset of the first...

Managers know better. 😛

I think you will have to create a package by hand or use the wizard.

That's what -00:57:00 looks to me.

What does a negative time mean to you?

See if this helps:

-- Source table with some sample values

DECLARE @source TABLE (

id int, -- to identify the converted values in the destination table

decCol decimal(19,4)

)

-- some sample values

INSERT INTO @source...

Let me ask one question: why replicate the database to SQL Server if you can access the data from Oracle?

I know, Oracle sucks. I hope there's a better reason for...

You could use the Oracle migration assistant

It's not as easy to use as it might seem and it hangs sometimes, but it kinda works.

It still depends on the client's language:

set language italian

select datename(dw,getdate())

Saturday is ...

There's no need for FULL recovery model on MSDB:

http://msdn.microsoft.com/en-us/library/ms365937.aspx

Actually syscomments is a compatibility view for SQL2000 and it should not be used. It splits the object definition on multiple rows when it exceeds 4000 characters. sys.sql_modules is the...

... or you can use Red-Gate's SQLSearch[/url].

It's free and easy to use.

You can use a query like this:

SELECT OBJECT_NAME(id)

FROM syscomments

WHERE text LIKE '%whateveryoulookfor%'

Hope this helps

Gianluca