I think what PEPEPACO_1980 is saying is to use a stored proceudure to parse out your XML instead of an XML data source adapter. Still use SSIS to process...

Is this a single user application? If not, how do you plan to keep the global temp table name unique for the thread that is creating it?

Using global temp...

What on Earth does that mean?

I'm sure if you can describe your problem in a way that we can understand what you are trying to do, someone can help you....

I'm looking forward to reading it!

Yes, that may help, but I think you'll still have some challenges to deal with. Data flows are coupled closely to the metadata returned by a source adapter. ...

OK. SSIS will not be able to resolve the metadata from a dynamic query so you'll need another approach. If you are trying to cut down on development...

Source adapters in your data flow cannot be dynamic. They must return the exact same metadata each time they run and the SSIS validation routine must be able to...

Florian Reischl (7/1/2009)

---

Should be possible with DENSE_RANK within a CROSS APPLY but...

First:

Your sample data contain:

101656 05/05/09 5' 6.5" 66.50

101656 05/05/09

101656 05/05/09 5' 5.75" 65.75

101656 05/12/09

101656 05/27/09

There is no uniqueness...

DECLARE @Table TABLE (cust_id int, date datetime, height varchar(10), weight varchar(10))

INSERT INTO @Table

SELECT 1, '01/01/2009', '5''2', '110lbs' UNION ALL

SELECT 1, '01/02/2009', NULL, NULL UNION ALL

SELECT 1, '01/03/2009', NULL, NULL...

Yep, great articles. Once you've generated trace data, it's just a matter of loading the trace data into a table where you can group/sum/search for the processes responsible for...

I'll ask again, is there a reason why you need to use a Script component as your source to read from a flat file? It sounds to me like...

You are 'unable' to run it on your other 2 servers? What does 'unable' mean? Do you get errors, do you not have access to the servers? ...

DECLARE @Address TABLE(Zip varchar(10), PlusFour varchar(4))

INSERT INTO @Address

SELECT '68114', NULL UNION ALL

SELECT '68132', '1234'

SELECT ZIP + CASE WHEN LEN(PlusFour) > 0 THEN '-'+PlusFour ELSE '' END AS FullZIP

FROM @Address

So you're using the Script Component as the source? Have you considered using a flat file conection manager instead?

Pretty straight forward concept, but we'll need sample data and schema to really help out here. From a high level perspective, here's what you'll need.

INSERT INTO DestinationTableName(Col1, Col2, Col3)

SELECT...