Just noticed a typo in the question.

The first line of text should read "non clustered index on EmailAddress" and not "non clustered index on LastName".....this script itself is OK....

Good tip!!

But you do have to hold down the CTRL key when you click on the link for the page to display.

I have configured the HTTP Connection Manager in SSIS to connect to the http://en.kingofsat.net/pack-skydigital.php URL.

Now I wonder if there is a way to work this into a Data...

Not too sure how you would capture the code....

I'll be working on this for the next while - If I get a SSIS package to take care of all the...

Ah! Excellent.....

In Excell 2003 I said Data->Import External Data->New Web Query... then put in the http://en.kingofsat.net/pack-skydigital.php URL and hit Go.

It imported everything at least into individual columns -...

Ha - classic! I think I broke every DBA rule in the book during my first year - You get to learn the hardway!

Ah - what a dummy I am - Had the GO on the same line - that'll teach me to be so quick to criticize. I'll have to wait 24...

The answer to this question should be NO.

The SQL as written will generate an error:

Msg 111, Level 15, State 1, Line 2

'CREATE TRIGGER' must be the first statement in a...

Thanks for the replies - yes I got it working my setting the Default value of the column to GETDATE() - so now when I import the text files through...

Thanks for reply.

I know how to generate the datetime of the import - the problem is where in the SSIS package can I add the task so that only the...

I ran this query in a new query window on SQL 2008 and got 1,1.

I got the correct answer of 1000 but only because 250 wasnt there which was the correct answer for SQL SERVER 2005. 1000 is correct for SQL SERVER 2008. Hope...