I would try using a Script Task. The following code (from http://msdn.microsoft.com/en-us/library/system.io.file.setattributes.aspx ) will handle it:

Dim path As String = "C:\File\c.xml"

...

I don't believe that this is an SQL XML question. You need to figure out what program is processing this XML and figure out how to get a SUM...

How do you identify files that have already been loaded?

Is there another task running at the same time?

How many columns are in the second table? Some rows look to have three and some look to have two. Also, it looks like there is a null...

Try:

SELECT x.c.value('text()[1]','nvarchar(max)') as Result

from EVENTDATA().nodes ('/EVENT_INSTANCE/AlterTableActionList/Drop/Columns/Name') x (c)

Some things to try (I don't have my environment up): GetItemType("/MyFolder"). It should return the string "Folder". I am unsure what it returns if it does not...

gadamson (3/11/2011)

---

Using SQL 2008

Sample Date:

<Listing xmlns="http://xx.org/2008-03">

<Address>

<commons:preference-order xmlns:commons="http://xx.org/2007-08">1</commons:preference-order>

<commons:address-preference-order xmlns:commons="http://xx.org/2007-08">1</commons:address-preference-order>

</Address>

</Listing>

-- currently declaring the...

A couple problems. You have a default namespace which you need to declare. I prefer using the "with xmlnamespaces" statement. Next, you are looking for a ListPrice...

You could use a script task to read a line from the file.

using (System.IO.StreamReader rdr = new System.IO.StreamReader(@"C:\Files\out.txt"))

{

...

So how do we contact you?

Is it the same "Type" that is mentioned in the other post? Yes.

Try this.

create table Menu (ParentID int, ID int, menuText varchar(100) , href varchar(100))

insert into Menu values (null, 1, 'Button1', null)

insert into Menu values (null, 2, 'Button2', null)

insert into Menu values...

I'm clear what you want to do. Do you want to combine all of the csv columns into an xml datatype and load it into one column?

=iif(Sum(Field!Delta.Value) = 0, ...)