damn thats bad luck on so easy a question :w00t:

How can 'you' assign 2 people the same id?

With stupidityDB our new database product for goverments and health oirganisastions.

Using our newly patented black hole data storage mechanism and void query...

See my thread.....

http://www.sqlservercentral.com/Forums/Topic622104-338-1.aspx

😀

--Shaun

yeah Phil we're all guilty us DB people of

1. Putting power in the hands of the stupid er I mean politicians. 😀

What we should always endeavour to do is...

please dont necro old threads its not polite

instead make a new thread and link to the old one please 🙂

And how do you access a property?

best practice = accessor methods/functions

therefore to retrieve the value of the property you should be executing a 'get' type function.

CURRENT_TIMESTAMP thus has to...

Hugo: so what you are saying is that REPLICATE uses varchar sizing i.e. 8000 and not the destination size unless you explicitly instruction the function to use something else as...

REPLICATE function is obviously broken then.

it only gives 8,000 repititions and thus must be geared to old SQL 2000 varchar max size of 8000.

Naughty MS have not updated the function...

My question was not

'how do you import a csv file using SSIS?'

but rather

'What specific objects from the tool box are the 'right' ones' to use to do the...

steveb (1/15/2009)

---

I would use SSIS, as this seems like a simple project to give you exposure to it. Also it is becoming a requirement for a lot...

Michael Earl (1/15/2009)

---

One thing to note. If you use the SQL Server destination component, the SSIS package must be running on the SQL Server that is the target. ...

Carla;

M25 - worlds's largest car park 😀 damn nuances for all US Citizens world's largest Parking Lot!

Done a bit of research

Microsoft SQL Server 2005 Integration Services By Kirk Haselden, Trey Johnson

http://books.google.com/books?id=jcnrBu32iu0C&pg=PA186&lpg=PA186&dq=BULK+insert+task+vs+data+flow+task&source=web&ots=1-X3Fc2eFN&sig=tvSGLVInDdtu2peQ8664NnqPHGw&hl=en&sa=X&oi=book_result&resnum=2&ct=result

These guys state that the prefered method to use should be data flow as...

I canunderstand Steve's loathing of flying when its west to east.

You take off stateside in the afternoon and land in the UK in the early morning 8 hours of flight...

When you say 'upgrade' what do you mean?

SQL2005( level 80 Compatibility) = SQL2000 behaviour?

or

SQL2005 ( level 90 Compatiblity) = Full on SQL 2005 ?

Changing the name may be the...