lmu92 (6/11/2009)

---

If I understand you correctly your data(=elements) "disappear" from the xml structure if the value is null.

There are two options I know of how to deal with it:

1) You...

Florian Reischl (6/11/2009)

---

For your second (if your attribute is not mandatory)

DECLARE @Scores AS TABLE (ID VARCHAR(3), Score VARCHAR(3))

INSERT INTO @Scores

SELECT '15', '95' UNION

SELECT '8', '55' UNION

SELECT '14', ''

SELECT

...

I'm sorry, the forums didn't display the example I wrote and then now they're transforming it to a an empty value rather than a null value.

The service that must consume...

Oh wow, thanks a million! I kept hitting that Advanced tab and kept seeing Memory Restriction and something about caching and didn't realize the bottom portion was a way to...

Yes, thats about my story, only minus the huge import.

Small import - only about 20 tables and not a whole lot of rows, but data that could change in...

I'm using the OLE DB Command. I hear it's not terribly efficient, but I'll eat my hat if I'm importing more than 300 records per table. We're looking at this...

Balaji (5/18/2009)

---

Hi Shawn,

One simple question. How do you perform the incremental load changes? Here we are using lookup and conditional split to check whether its a new row or updated...

Okay, those are a lot of good reasons. Now most of them seem to imply that stage is on another instance of SQL server, preferrably on another machine. Ours is...

Outside of the BIDS. Inside I'm fine. I was trying to change an xml value and run the DTS package when I got the error.

Yes, inside the studio things...

When I turn on Package Configurations (and use a variable) I start getting an error: DTS_E_PRODUCTLEVELTOLOW.

I don't have SQL Server or SSIS installed on my machine, which seems to be...

Okay, that sounds easier than I thought. Just do the import for one, but make sure you're using the Package Configuration to store all the variables like server info.

I was...

You, sir, are all over the place!

I'm looking into package configurations right now.

Is it even possible to have 4 ds's (data sources) going into one data transformation? Or would...

First off, let me say that this is great! I'm looking at it and after playing with it a bit I've learned a few new techniques ordering subsets, tables, using...

Jeffrey Williams (5/11/2009)

---

Not sure what VPN...

Here is the first part, which is the data side. This takes data being tracked for each student/subject with instructor information and sumarizes this by Instructor in another table. Then...