Yes, but the thing we need to know is...How did you fix the stored proc?

Oh, what a great question.

Come on, this was a bad one.  There's no info given about the current tape system.

Never mind, eh.

How very cool.

Still, a bit tight on your son though

If you click on 'Site Settings' you can change the text that is displayed.  You probably want more control than that, right?

I'm not sure if it would be easy to...

Thanks to everyone who has responded: I've got a lot of info now (and one working prototype).

You are a genius - a bit of tweaking and I think we have a winner 🙂

Thank you.

Thanks for that suggestion.  I'm going to have a play with this, because I think this might be just what I need 🙂

Thanks for the responses.  It looks like a SQL script is a no-no.  Stripping the quotes is ok, except I can't get the data into the table in the first...

That's the approach I was thinking made most sense.  Thanks for the response 🙂

Haha!  I didn't know this, but I guessed the correct answer (w00t!) and then opted for answer 4 anyway, because it made me laugh.  Gutted it was wrong though!

Right, I see what you mean.

In terms of validation all we need is a unique integer.  There is no range that it has to fit into, except the limitations imposed...

Fun - yes...

Thanks for the information.  Now to see how I get on!

When you talk about verifiable and validated what do you mean in this context?  Are you saying that ints cannot easily be used to identify a record just by looking...

Bulk Insert will work, but perhaps not in the parameterised way that I am trying for.

The parameterised parts are: destination table name, source file name, and (potentially) format file name.

Bulk Insert is significantly quicker than using 'text file source'.  However, that may not be so relevant with these new data loads as the amount of data being loaded is...