Viewing 15 posts - 31 through 45 (of 3,232 total)
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...
June 23, 2016 at 9:13 am
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...
June 22, 2016 at 12:23 pm
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!
June 22, 2016 at 12:07 pm
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...
June 22, 2016 at 11:19 am
What are you using for the import? How did you set it up? Is the file delimited, and by what?
June 20, 2016 at 12:38 pm
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...
June 20, 2016 at 11:11 am
Here's a walk through on how to set it up. Hope this helps....
June 20, 2016 at 9:20 am
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...
June 17, 2016 at 8:57 am
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...
June 17, 2016 at 8:08 am
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.
June 16, 2016 at 5:25 pm
This seems like a pretty straight forward query. Can you show us what you've tried and where you are stuck?
June 15, 2016 at 3:41 pm
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...
June 14, 2016 at 8:42 am
Is it the same table that gets truncated regardless of the account?
June 8, 2016 at 10:33 am
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...
June 8, 2016 at 10:02 am
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...
June 3, 2016 at 8:29 am
Viewing 15 posts - 31 through 45 (of 3,232 total)