ERWIN or ERStudio

May be Red Gate aso does the same, but I have not yet used it.

Embarcadero is a nice tool to compare databases. I have used it extensively

ooops! data for the previous post

create table t1(f1 int, f2 int)

create table t2(f1 int, f2 int)

insert into t1 values(111,222)

insert into t1 values(222,222)

insert into t1 values(333,222)

insert into t1 values(444,222)

insert into t1...

select t1.f1, count(t2.f1)

from t1 left outer join t2 on t1.f1 = t2.f1

group by t1.f1

Christmas Holidays are the best part of the year for our entire family and friends.

This time is more special. My son is coming back after his first semester at college...

i agree with Ronald San Juan

There is something weird going on in your env

Srinidhi,

Sorry to get into sermon mode. But...

The job at hand is one of huge volume.

To get to a viable solution, we need to understand

the data in and out. Till your...

yes indexing on the second column will increase speed.

In fact I concatenated both the columns and created a new column in the table and used that new column for the...

Bulk Insert task does not provide much flexibility. If you want to conditionally insert you may want to use Transform Data Task

Stored Procedure output to Excel

================================

Step 1

======

DDL and DML

===========

if exists (select * from sysobjects where name = 't1')

drop table t1

create table t1(f1 int, f2 datetime)

insert into t1 values(111,getdate()-10)

insert into t1 values(222,getdate()-11)

insert...

if exists (select * from sysobjects where name = 't1')

drop table t1

create table t1(f1 int, f2 datetime)

insert into t1 values(111,getdate()-10)

insert into t1 values(222,getdate()-11)

insert into t1 values(333,getdate()-12)

insert into t1 values(444,getdate()-13)

insert into...

do not use 'print' in Stored procedures, if the SP is called from frontends. Specifically ASP pages do break, if they call SPs that contain Print statements. More problemsome when...

great Greg! I was searching for synonyms

yep, you can do this very easily in your activeX script of Data Transformation task, as long as your database column is a char/varchar field

I would suggest a Multiphase Data Pump (Data Driven Query Task).

And you can use the lookup feature for looking up for insertion/updation/deletion.

If you nhave not done these, it may take...