I checked this out using your method, as well as creating a linked server to the Excel file.

No matter what you do with the data, even using CAST or...

Here's a guess: the wizard knows nothing of the other connection, so better to not use the wizard. It depends also on what you're trying to do.

You should probably...

You'll have better luck in a .NET forum with this question.

We're using IBM Ascential's DataStage 7.1, but it costs around $80K, and the number of skilled users is not large. We've already got the software (back in 2003) but the...

I've done this before in a situation where there was nearly 100% turnover in a company's IT department.

I just used Profiler (as ramses2nd is suggesting) and trace the databases...

Yes, I forgot about that field, and it is populated for the most part for the trace I'm running now.

Thanks!

We'd need to see the DDL code (CREATE TABLE statements).

You might already know this, but in Query Analyzer, if you make the Object Browser visible, you can drill down...

Mick,

I'm using SQL Server 2000 sp3 and I'm getting the 's' on the end of my string. So if you're not, you must be doing something differently. What size are...

You'll have to tell us how you DELAREd your variable @sPool.. also, did you initialize it to a certain value? Or is @sPool an input parameter?

If I do this:

declare @sPool...

The Newbie forum gets a lot of traffic..

If the other 2 dates are always going to have the same relationship to the first date, I would use a view as an interface to the table, and would...

It's looking like my best bet in this case is to re-create the table on the destination server WITH a PK identity(1,1) column and do an INSERT INTO .. SELECT...

As an aside, I would write the query to use table aliases, like this:

SELECT T.TBPLNR, T.TBITEM,

T.TBQTY, T.TBOPDT,

G.GDMIN

FROM AIMPDTA.GDWITM G, AIMPDTA.TBPLAN T

WHERE G.GDWHSE...

If you want to use a join:

INSERT INTO Table2

SELECT tb1ID, tb1Name, tb1Description

FROM Table1 T1

LEFT OUTER JOIN Table2 T2

ON T1.tb1ID = T2.tb2ID

WHERE tb2id IS NULL

-- the keyword OUTER is...

If the login that owns the db has system admin rights (which yours does), the owner of the database objects will show as 'dbo', but if the login that owns...