Hello,

I'm getting:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'fn_trace_getinfo'.

Tony

The message says

(2 row(s) affected)

begin transaction;

Insert into CE_CUSTOM..GL_Transactions

(

SOURCEINTERID,

SOURCETBL,

DEX_ROW_ID,

SOURCDOC,

OPENYEAR,

OPENMTH,

OPENDAY,

ACTINDX,

ACCTTYPE,

ACTNUMBR_1,

ACTNUMBR_2,

ACTNUMBR_3,

ACTNUMBR_4,

ACTNUMBR_5)

Select '

(2 row(s) affected)

The two rows affected are:

GL20000

GL30000

Those...

So I am running into some difficulties when running the script.

1) I first have to get a result set of the available companies. This is from the beginning...

Wow!!

GSquared, this is whole new territory for me. I am going to do some tests and try this example.

Thanks so much for your help, ideas and getting me going...

I've never heard of that before. Creating a table with dynamic strings? Let me try to create a table and see if I understand what you are saying.

Thanks...

It may be, but I think the problem is scrolling throgh the resultset one at a time.

We get a company from the initial resultset, query the GL20000 table and insert...

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) ...