Hi,

Once you said remove the values it hit me.

This is what I came up with:

// Move the data to the new field preserving original values

UPDATE dbo.StagingTable

SET ...

Steps:

1. Taking the XLS data and using the bulkcopying object to a staging table (using C# instead of SSIS)

2. From within SQL Server 2008 I'm trying to parse the string...

Also these servers are VMs not physical servers.

We have 24GB of RAM where in the old servers were running 32GBs where the sys admin is stating the additional reads from no indexing caused massive delays.

Not sure what...

Not sure what you mean. Can you be more specific?

Regards,

I figured it out. Using a type of Extract functionality to retrieve nodes

Thanks,

Thanks for the reply:

The current system is using Info-Path (I haven't seen the code-base at all) and they are caputring user information and putting the data into an XML file...

Thanks Everyone!!

I Google first looking for

dynamically building tables in SQL

Create table based on SQL

SELECT Into

I couldn't remember the exact syntax and it was driving me nuts. It was one...

Duly noted. I did my homework before posting and couldn't find it. There's alway one in the crowd.

Thank You All

Hi,

Try this function to loop through all databases

--This query will return a listing of all tables in all databases on a SQL instance:

DECLARE @command varchar(1000)

SELECT @command = 'USE ?...

Thank You I'll have my tech lead look into this.

I was trying to load additional parameters. I didn't have that set before and still encountered the same issue

Unfortunately this is on a SQL Server 2000 environment. However I'll definitely give the cursor option a try.

Thank You very much