Can't get the schema to paste. Must be doin something wrong. Try again......

<xs:schema xmlns:sql="urn:schemas-microsoft-com:mapping-schema" xmlns:xs="http://www.w3.org/2001/XMLSchema" elementformdefault="qualified">

<xs:annotation>

<xs:appinfo>

<sql:relationship name="BetDetails" parent="Bet" parent-key="BetID" child="Selection" child-key="BetID"/>

</xs:appinfo>

</xs:annotation>

<xs:element name="Message" sql:is-constant="1">

<xs:complextype>

<xs:sequence>

<xs:element name="Bets" sql:is-constant="1">

<xs:complextype>

<xs:sequence>

<xs:element name="BetDetails" type="BetDetailsType" minoccurs="1"...

Oops, schema failed to paste. I'll try again. Cool project BTW. Importing bets on the GGs lol

Here is the script to create the test tables I used

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_Selection_Bet]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[Selection] DROP CONSTRAINT FK_Selection_Bet

GO

if...

Do you want to post a sample data file and the database schema you are trying to import into and I'll try and put something together.

Why are you declaring a DataReader as Dim oDr As SqlClient.SqlDataReader, you don't need/use one?

Also why do you call the stored procedure/command twice i.e.

oCmd.ExecuteNonQuery()

oCmd.ExecuteNonQuery()

This might be why it's inserting twice...

Try adding a Dynamic Properties Task, create a Global Variable called ServerName and set the Data Source of each of the connections to read from the global variable. Make...

The only thing I've seen of this nature is a trace set up to monitor SELECT access of particular tables/fields and write this to a file. Periodically load and...

select @minsize_sql = N'SELECT @min_spidx_size = (3 * avg(((emaxx - eminx) + (emaxy + eminy) / 2))) min_avg_edge from '+@fulltablename

exec sp_executesql @minsize_sql , N'@min_spidx_size float OUT' , @min_spidx_size = @min_spidx_size...

I presume you have a record with a new line (CRLF) within a field. Have you got text qualifiers switched on ? What are the delimiters ? Can you...

You need to check the value of the variable and assign System.DBNull.Value to the sql parameter value, not the variable. e.g.

Dim customerName As String = String.Empty

Dim prm As New System.Data.SqlClient.SqlParameter("@name",...

This is a very simple example of a vbscript that periodically requests an xml file at a url and saves the contents. Obviously if you are using .net you...

If the hierarchy is definitely that one item can only have one parent, this is the classic problem of hierarchical data in a flat table. There are a number...

In my opinion I would suggest looking more closely at the construction of the ASP pages before you start questioning the performance of the database. Certainly stored procedures will...

It's suitable in most cases where execution of dynamic sql is required.

Directly from BOL

"Using sp_executesql is recommended over using the EXECUTE statement to execute a string. Not only does the...

I'm not sure I understand why you have two connection strings, client and server side if it's a VB client app ?

The only times I've encountered this error before are...