Hello Divya,

I haven't work SSIS in a while. We have since moved on using BizTalk.

Hello

Actually, I haven't gotten this far myself. I ran into issues getting my XML file to validate using a provided XML schema. While trying to get this to...

I'll review these suggestions and get back with you guys later.

There will only be one policy in...

I am sorry. I meant Jeff. 😛

Yes... once flattened, you can do just about anything you need to...

Hello Jim,

When I originally read your solution, it seem like you got the impression that I was looking to take the data from application and create a database table that...

This is an insurance application.

There are cases where we will need to derive columns information based on a combination of data we received in the application.

For example, we have to...

Here's an example:

<al99999>

<>

First Name, Mark, 0

Middle Name, Stan, 0

Last Name, Richards, 0

Address, 1003 Test Drive, 0

City, Atlanta, 0

PostalCode, 30071, 0

This is still a test and it represents an application. ...

Jeff Moden (3/18/2008)

---

How many of those "unique identifiers" and sections of names do you have in a file and are they all the same (not the names, the over all...

Tim Mitchell (3/18/2008)

---

Tony,

Welcome to SSIS. You might be able to use the flat file source, but you're going to need to stage the data in a staging table to...

Hello,

Thanks for the reply. What I ended up doing was purchasing the book Professional SQL Server 2005 Integration Services. I found the answer in there, but I ran...