Are you wanting to take your XML file, and flatten it out to a flat file output? What exactly is your end goal?

If your XML files are not all of the same format, then you will not be able to utilize a For Each Loop to import them. Using a FELC implies...

You need to check and see that your XML is valid first before trying to read/process it. There is a SSIS task for XML validation utilizing an XSD file. Incorporate...

Does the table have a lot of records (millions)? If so, you may want to look into doing your delete statement in batches. I've had many problems with trying to...

A good tool to provide visual cues if connection strings are being configured elsewhere is BIDS Helper[/url]. If your connection string is being set by a package configuration, a Blue...

You can use the XSD validation in SSIS. However, C# allows you to do more granular error checking, as opposed to doing XML structure validation. If you need to accommodate...

Is there any particular language that you are looking to accomplish this in? I have some examples in both VB.Net and C#, with the C# example being much clearer. I...

Wow, I feel stupid. I was way overcomplicating things. Thanks for the help, Wayne!!

You need to add a precedence constraint to each of your script tasks to determine which one should run depending on the outcome of your variable from your script task.

You could try one of the earlier downloads out on Codeplex. I didn't see anything explicitly stating SQL 2005 compatability, but it's worth a shot.

Within SSIS itself, you have to add the SharepointList Source/Destination adapters to your toolbox. Open your package in Visual Studio. Then navigate to Tools --> Choose Toolbox Items. Click the...

The lookup transform adds all of the records to the lookup cache before it begins processing your package. Execute your package and then go to "Progress" tab. You will notice...

Another thing to consider: Make sure that your queries are set-based, and not operating on a row-by-row basis. Jeff Moden has an awesome article detailing RBAR (as he calls it),...

Are your databases that these packages going against located on a centrally-located server? Meaning, do the databases reside only on your co-worker's machine? Or are they accessible by everyone in...

Perhaps this post would be of help?

http://www.sqlservercentral.com/Forums/Topic997589-21-1.aspx

It was a question I posted in the XML forum last week. I needed to extract a piece of data from my XML fragment...