Not sure I fully understand..

You have:

1. A flat file with Column1,Column2,Column3 and no delimeter

2. You need to split the data as TableA (ID,Column1,Column2) and TableB (ID,Column3)

I PM'ed you

Hi there henry,

I know this post is quite old, however it would be interesting to find out if you have found a solution?

Regards

Thanks for the input...as mentioned in the original post...the objective is to monitor the health across multiple servers and multiple instances.

I will download and try the mentioned packages and hopefully...

Great thanks ...for the input.. it is most valued

Hi Dave23,

Thanks for the response....We are using SQL2005 at the moment and are considering upgrading......so this might just be the nail in the coffin...:)

One question though... does the 2008 native...

Run the following, it will produce "Last_Updated"

DBCC SHOW_STATISTICS ('TABLENAME',INDEXNAME );

I would suggest using SSIS Packages.

Read this on how to resolve some collation conflicts:

http://www.sqlusa.com/bestpractices2005/collatedatabasedefault/

HHmmmm....

Try Now:

http://www.sqlservercentral.com/articles/Large+Data+Sets/68930/

Might be your worth reading this article on SSC

http://www.sqlservercentral.com/articles/Large+Data+Sets/68930/">

http://www.sqlservercentral.com/articles/Large+Data+Sets/68930/

1. Is this inserting T2 to T1 a recurring event or a once off?

2. Is T2 structure a mirror of T1 structure?

I...

The error occurs in the ORDER BY clause as no columns by the name of nCount exists

replace :

ORDER BY nCount, PracticeAddressFirstLine, Name

with

ORDER BY nPracticeAddressFirstLine,PracticeAddressFirstLine, Name

Interesting though.....:cool:

This might explain it

Due to the fact that the sub-query in a correlated sub-query can be executed for every row returned in the outer query, performance can be degraded....