Maybe, but with what you are asking for, someone will have to mock up an...

SSIS is very metadata dependant. Each source, destination, and the transformations that you put in between them rely heavily on the metadata that SSIS gets from the source and...

Some of that depends on how you will be using your backend database. Is the application using it, is it kept around for compliance, is it used for reporting,...

The Conditional Split transformation is what you'll need to pull off a CASE statement. It will let you bucket, using expressions, your data in your pipleline and route each...

What does the query plan look like? Do you have an index on the account type or class code columns?

How about providing us with your table structure, sample data (in a readily consumable format) and an example of the output your would want to see based off of your...

Checkai gave you exactly what you asked for. If it does not work, how about showing us an example of some data that you want filtered out that this...

Yes, you definately want to use year/week and not have weeks from different years in a partition. Here's a great article on table partitioning that uses a sliding window...

I see from your link that :

It must just do a basic structural validation. You'll...

I did not say to not use a CTE. Its just an alternative way of coding the same solution. As far as ease-of-reading goes, they're almost identical w/...

You'll notice if you look at the metadata for each of the outputs from the XML source, that the parent node ID is included as metadata for the dependant nodes....

Just an after-thought Greg, but I wanted to point out that you can still do schema validations with the incomming xml using schema collections. I'm not sure if that...

Thanks for the update Greg. You should get a pretty good pat on the back for that improvement....from 100 to 40,000! That's impressive!

There are 2 ways we learn, mentors and mistakes. A mentor can be a person, but it can also be a support group like SSC or your local user...

Can you provide sample data to show the problem you just described?