decision

bump

Management Studios does not have the ability to sync databases for you. You can do a stare-and-compare by visually examining 2 different DBs, but it will not do the...

moving on??

Add a conditional split in your data flow that looks at the column you want to check. Then route the rows that match the condition to an OLE DB...

IF OBJECT_ID('TempDB..#test','u') IS NOT NULL

DROP TABLE #test

SELECT TOP 1

[name],

...

Kofta

SELECT OBJECT_NAME(object_id)

FROMsys.columns

WHEREname = 'column name here'

Declare @strStartTime varchar(50)

select @strStartTime = '12/10/2010'

SELECT CAST(@strStartTime as datetime)

Congrats!!

Where's you blog site?

...nevermind 🙂

Drum roll pease.....

Ditto

jscot91,

Is this a new question from a new poster or did you change user names?

If this is a new question from a new poster, please post a new thread...

An execution plan here would help a bunch. You shouldn't have to bother with the temp table to make this work.

The challenge with adding Status to the clustered index...