Thank You!

Thank You.

Can I set a variable within the data flow task after a conditional split without using a script component (not sure how to write the code to...

Thank You! That fixed it. This is a super forum.

Would you be willing to connect to my machine via netmeeting so we could figure out what is wrong?

removed the quotes, still no luck.

PEPEPACO_1980 (7/6/2009)

---

remove the extra quotes from the xml if there are some, replace for the scape code for xml, i dont remember the code, but, that should work. there...

Thanks for spending so much time with me. It is still not working. I tried adding ServerFamilyTotal but it does not help. I do not think that was the...

Can you verify you are using this file?

...

Thanks - but your code did not fix the issue. Still no rows inserted in the table. What is your table definition? Mine is

USE [xmltest]

GO

/****** Object: Table [dbo].[MODEL] ...

Thanks, but it still does not work. What can I try to find the issue?

The file is being read fine - When I do a "SELECT @FileContents as FileContents" I see the file contents. But no rows are being inserted into the model table.

Thanks for the help. I was able to pull the XML file contents into a variable, but I am unable to get it in a table. Here is...

Ok. I tried that and added some declarations, but get a syntax error.

DECLARE @FileName nvarchar(50);

DECLARE @EXECCmd nvarchar(50);

DECLARE @strXML nvarchar(max);

SET @FileName = 'c:\data\test.xml'

SET @ExecCmd = 'type ' + @FileName

set...

I created the procedure

USE [xmltest]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[SP_GET_MODELS] (@strXML xml)

AS

BEGIN

insert into MODEL

select Tbl.C.value('@name', 'nvarchar(50)') as [name] ,

Tbl.C.value('@val', 'nvarchar(50)')...

XSD

...