Yes, that is correct.

1) First it creates a result set of companies which could be 500 rows.

2) Then it looks at each company's database

3) It finds either...

Thanks for your help.

I believe our server is under a heavy load at times. We are currently at service pack 3. So this fix should already be on...

Hello,

I am running SQL Server 2005. It is set at 0 for unlimited connections.

Tony

Ok now I am really confused.

DBCC CHECKDB return a bunch rows results of course. But at the end, it returned this message.

CHECKDB found 0 allocation errors and 0 consistency...

Thank you.

I read the article and will still do some more studying. I am running DBCC CHECKDB now.

Tony

Hi,

After digging into this a bit, I see what I need to do is turn on the multi-phase datapump.

Doing this, I can code for insert failures. I've also...

Hi,

That is exactly what I am asking. :w00t:

How would you set up a Transformation Data Task to send error rows to an error table and still process...

At the top of my list to my boss was the fact we need to have backups.

Again, he liked my recommendations and gave me the go ahead to work on...

Thanks everyone for the feedback.

It was very helpful!!!

I made an extensive list of things that need to be worked on:

1) Backups

2) Test Environment

3) Migration process

4) ...

Well...

I got it to work. I found someone that said make the text qualifier "none".

I was then able to parse the flat file.

It is still odd...

Thank you. That makes sense.

If I am printing reports through Microsoft Office using VBA to supply the images that works well.

If I use Crystal Reports, I think I would...

Hi,

I couldn't use SSMS because it was giving me an error message. I tried but since the tables had a lot of data, I couldn't just move the columns...

By the way, what is SSMS?

I know DTS and its big brother SSIS. But what is SSMS?

Thanks,

Tony

Thanks everyone!

And yes I get it, the column order shouldn't matter.

I was just thinking of nice and neat tables all matching with same order. But as Gail said it...

Jeff,

Trust me. I said the same thing. Why does the first and second row have to start with 0x100? That was the way the application was written...