Yes I do have access/license for Visual Studio .NET 2005 and 2008.

Bradley Deem,

Well, as I go fighting for the license of this sql edition needed for SSIS to our management, I think that is not possible. We're just using express edition.

How...

robertm (12/10/2008)

---

I think this is the misunderstanding.

You can use SQL Express edition as a data source within SSIS however you will need SQL Satndard edition to implement SSIS itself. That...

CozyRoc (12/9/2008)

---

You cannot use SSIS with SQL Express. The SSIS components themself are not included with this edition.

Having said that, you have 2 options:

1. Deploy better equipped version of SQL...

Thank you guys for the inputs.

Alan,

I'm just a little bit confused why you said...

I ran into this Microsoft forum and it seems interesting...it seems SQLEXPRESS doesn't have SSIS:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=238335&SiteID=1

(see post from cajinamaster and reply from Phil Brammer)

and also this: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3618597&SiteID=1

So...

anam (12/8/2008)

---

i found a link where...

Alan (12/8/2008)

---

SSIS sounds like the right tool for this task. It will definitely work with Express Editions.

One issue you will have is that express edition does not have Agent...

anam (12/7/2008)

---

in my opinion, SSIS would be better approach to follow. I/O of files and playing with XML data makes life more easier in SSIS. Also, there is extensive inbuilt...

This is how I came up with the result on scenario 1.

--===== Populate the table with the second example data

CREATE TABLE #MyHead

(

Row_ID...

Hmm..let me trace on how did I come up with the said result, I'll just use script number 6 (Sixth Data Scenario) since it has less data.

--===== Sixth...

Yes I did and it gave the correct results for those scenarios that I gave. Sorry but I just come to think on another possible scenarios and tested the script....

Sorry for that one Jeff, I already edited my previous post since that was incorrect..I really apologize for that one. The correct scenarios with thier respective result is written below:

--=====...

Hello Jeff,

Thank so much for the great solution and prompt response. The link that you gave really was a great help for me to heads up on the proper posting....