If you are having an issue connecting to one specific server, you need to simplify your scope. Get rid of the looping and variables and run your task against...

I'm with RonKyle on this one. I've built out many datamarts, some small, some large. All of them have included RI constraints from the fact tables to the...

I'm a little confused on your requirements. Can you post some sample data and the desired results based off of that sample data? That would help tremendously!

I would agree that you don't need to update a flag column in your left table. You are working with relational tables here, so the left join itself tells...

What are you using for the import? How did you set it up? Is the file delimited, and by what?

You could use the XML source for this, but you would not need to save each row to it's own file. Dump all rows into one XML file and...

Here's a walk through on how to set it up. Hope this helps....

http://www.sqlis.com/sqlis/post/The-Execute-SQL-Task.aspx

Yes, Jez, that would work just fine. Eliminates the need to check for file existence. Plus, you can use the for each setup to include the file mask...

If the files were all the same format, then the for each loop method would be my choice as well. But I'm guessing since you said they are different...

Can you give us examples of how the file names vary? Is it just a datestamp added to a base file name? Examples will help drive the solution.

This seems like a pretty straight forward query. Can you show us what you've tried and where you are stuck?

Is there something specific that you are struggling with on this? For starters, you'll need two sources in your data flow (one per file) and then you can merge...

Is it the same table that gets truncated regardless of the account?

Just to be clear, your not truncating this mater table? Are you saying that each account has it's own table and that you want to truncate that table based...

At this point, I'd consider taking out the looping, variables, and expressions and just set up a task to hit that server. Remove the dynamic SSIS stuff and just...