I have tried doing the same with a Default Instance of SQL 2000 Standard, and have the same result.

Thanks...

The most annoying performance issue reported to me was when accessing the server with Enterprise Manager, apparently some people still do . ...

Please ignore this post, i just realised it is in the wrong category

Do you have a "create table" SQL task before the pump task?

Try this, should be a lot more effective...

Create table TblPublisher (Pub_ID int identity(1, 1) constraint PK_TblPublisher primary key(Pub_ID), Publisher nvarchar(255))

go

create unique index IX_TblPublisher on TblPublisher(Publisher) with ignore_dup_key on primary

go

insert into...

You can also a query Sreejith's statement, using a case statyement, that should properly pivot the data, if that is what you need.

It is probably not the best way of...

We have just re-installed the whole machine from scratch, windows, office, sql, etc and it seems to be working now.

Thank you for your replies and patience...

There is also a way of storing data about the different formats ("versions") of the files in a table.

All you have to do then is to ensure that your DTS...

Hi there

This is basically what AJ also said... Try this:

select * from TblName

where

convert(smalldatetime, cast(MonthField as...

Please post your "INSERT" statement...

Happy to help.

i had a lucky guess, i guess...

I had the same problem before as well.  I am not sure what your DTS does, but if for e.g. it exports to a file, the server will need to...

I agree.  You either have the cat by the tailpiece, or you are giving us insufficient info, hehehe

There are actually a couple of ways to do this.  I use the folowing:

declare TextColumnCursor cursor for select name from syscolumns

   where id in (select id from sysobjects where...

Do you need to load image data into the database?  From personal experience and advice I received before I would think it better...