Try

USE master

to set up your new database

and

USE whateverYourNewDatabaseIsCalled

in your command strings

Unless there's a not null constraint you can have one null value in as this 'does not break the uniqueness if the primary key values'

Personally, my view is this is...

!

It does say that, doesn't it. Wonder if :I've never tripped over that one before over the past almost 2 decades or what.

Not very intuitive though - it's a...

Surely, if you have a column you do not wish to display in an XML Document, and it's always going to be called Id, or C1, or whatever - rather...

PaulB (10/11/2008)

---

GilaMonster (10/11/2008)I don't see why I would want to fail the entire load if I know there's dups in the source data that, for whatever reason, cannot be removed...

For any of your simple recovery databases, you can do so by backing up then doing...

If the conditional split doesn't meet your nees (for example if there's a variable number of potential destinations) you could use a script task to set the properties of an...

You could get a bit of space back by doing a backup of 2 then - as you're in simple mode do a log backup with truncate only. This...

So are we talking about using web services in SSIS for say a datasource, or to control other things, such as which report(s) to run and what to pass to...

What are webmethods, and for what purpose?

If it wasn't appropriate to use a well matched datatype why the errrrmmmm heck would Db vendors put all that time and effort into providing them in the first place?

Jamming...

Adding indexes to the system would not be an option for a couple of reasons;

1) If - as is extremely likely - the app's a third party...

Wilfred van Dijk (10/3/2008)

---

Generally, you'll get the most benefit of a (clustered) index if you add columns which are most used in your where clause.

In your case EMPLID. But Clustered...

Any developer that does not do this, is a lazy developer and a person I definately do not want on my team. A little harsh maybe, but I've had...

Ken McKelvey (10/2/2008)

---

Kenneth Wilhelmsson (10/2/2008)

---

This is really another subject, but I feel I have to disagree anyway.

What you're essentially proposing here, is that the model doesn't count.

Whenever you're using 'select...