So there's no relationship between the header and detail other than the IDENTITY?

Maybe you can add the current user and datetime to the tables. You can use a format file...

There's not much in the way of practical use of Lookups. Generally, data is imported into a staging table and fields updated as appropriate using a stored procedure. This is...

First thing I'd do is drop all that scripting.

Create two staging tables, one for your AS400 data, one for your NT data.

1) Import your data using a Datapump task...

How about BCP'ing the data into a table with a single field. Then insert the resulting data into your destination table.

You might use a cursor to scroll through the...

Try putting the last line of the original file into the new file.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Sounds like some sort of logging file created by the third-party. How about renaming the file and creating an empty file with the same name?

Hope this helps

Phill Carter

--------------------

Colt 45 -...

I use the following script to find single items. You could possibly wrap this in a select from sysobjects and syscolumns to generate some sort of cross reference. Of course...

Can you post your procedure code?

Two things you might want to check,

1) Do you have a RETURN statement? If so, try removing it.

2) Change your temp table into a normal...

I'd suggest holding the phone till you evaluate SQL Reporting Services. Beta2 looks impressive. The range of output and delivery options is great, and you can roll you own. It's...

Running ActiveX Script while importing significantly slows down the import process.

One solution would be to import the file into a single field and then use some stored procedures to wash...

Yes, I'd still use staging tables. Instead of using @@IDENTITY use SCOPE_IDENTITY(). Check BOL, @@IDENTITY returns the last identity created across any scope in the current session, SCOPE_IDENTITY() relates only...

Lookups in DTS are often used to add, or replace, data to the import process.

For example, you get a list of products with new prices.

The source data has,

ProductName, NewPrice

Your...

How are you viewing the resultsets?

If you're using ADO, you'll need to use the NextRecordset method.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

Try this,

use pubs

go



CREATE PROCEDURE au_info 

@lastname varchar(40) = NULL

, @firstname varchar(20) = NULL

AS 



SELECT au_lname, au_fname

FROM authors

WHERE (au_lname = @lastname or au_fname = @firstname)

go



EXECUTE au_info @lastname...

From BOL

quote:

---

Length of a string containing SQL statements (batch size) 65,536 * Network packet size.

Network Packet Size is the size of the...