And how does SELECT object_id FROM forms_holder perform?

What is the size of the table in MB?

Please try

SELECT [object_id]

, [form_family]

, [file_name]

...

Thank you - it would be good to know how the OP got on..hint.hint...

AVB (1/25/2011)

---

I've tested the DSN with various settings.

The DSNs use:

SQL Server Driver

For the server I've used Public or Internal IP addresses and FQDNs depending if I'm local or not....

rjohal-500813 (1/25/2011)

---

Rahul The Dba (1/25/2011)

---

What will you do with that ????????

Still i am answering...

MB-400824 (1/24/2011)

---

Hi,

I have two users on a SQL Server 2005:

1. Windows AD account, which has admin rights to the SQL Server.

2. SQL Server account, which is given individual...

How about using a new database and creating uniquely named tables - perhaps include the SPID in the name

Ok, so can you show the settings for the DSN - change any sensitive information - and how you use it in the application?

Yes, that is the one, give it a try if you can - I can't promise it will help, but hopefully...

If you are not concerned about modelling the source database, then things are certainly better.

Ask for the XSD documents so that there is not guesswork involved and then use SSIS...

If they provide one you stand a much better chance, but you should still review the tables...

I appreciate your hard work and thank you for sharing - as with all these things I hope that the outcome of the discussion will be a revised article with...

hxkresl (1/25/2011)

---

I have been supplied with XML files in place of direct access to the source database, for extracting the source columns containing the data that needs to be ETL'd...

When you set up an ODBC using the ODBC control panel applet, the first thing you choose is the Driver.

Here you can choose SQL Native Client if you have...

XML documents use an xml schema to define the content architecture.

An xml schema (XSD) can be "inline" - contained in the xml - or a seperate file.

IF you have xml...