Viewing 15 posts - 151 through 165 (of 698 total)
I could be wrong, but I'm pretty sure that excel 2007 files require a different connection manager than 2003. Did you try running two loops instead, one for the .xls...
December 27, 2011 at 9:01 am
The empty template approach is the one I use as well. I find it makes things easier to deal with, since I can set up the mappings beforehand, and then...
December 27, 2011 at 9:00 am
Would it be possible to upload a copy of your .DTSX file so I could take a look at it?
I just tried it to double check, and it worked no...
December 22, 2011 at 12:32 pm
What doesn't work about that?
Just from face value, it looks like it should work fine. I've definitely used expressions based off variables that are set through ForEach loops, and never...
December 22, 2011 at 12:02 pm
Unless you have a fairly powerful computer, I can almost guarantee that using the Aggregate task *will* cause it to crash.
For reference, the biggest working set I've dealt with is...
December 22, 2011 at 12:00 pm
1) Yes you can, using the Aggregate task. This lets you do effectively the same thing as GROUP BY in SQL. It's not really recommended though, unless you have no...
December 22, 2011 at 8:56 am
Yeah - also a good solution, although that one depends on the fact that the only files in that folder will be the ones you want to process. If you...
December 21, 2011 at 1:35 pm
No probs. Let us know if everything works out properly!
December 21, 2011 at 1:30 pm
Yes to all counts 😛
SSIS has a wonderful feature called "Variables". They work pretty similarly to variables in normal programming environments.
What you can do is have a variable which is...
December 21, 2011 at 11:32 am
Lol - okay, got those two reversed, but you get the gist of it 😛
December 21, 2011 at 10:42 am
The Execute SQL Task can be used either way. You can put in the stored proc, or you can put in the code, whichever you prefer.
December 21, 2011 at 10:23 am
Updates aren't done in a particularly efficient fashion in SSIS.
SSIS functions as a pipeline stream, with rows being read from the source and fed to the transformations and then the...
December 21, 2011 at 9:23 am
What do you mean by the current isolation level supporting my requirements?
December 19, 2011 at 7:39 am
Okay... never mind. Found the solution.
Turns out that the problem *was* actually my Expression. I had put in a template query to get my columns, and then in my Expression...
December 16, 2011 at 8:37 am
Yeah Elliott, that's what I figured - had basically already started that anyway, since I was fairly sure there wasn't a better solution. CozyRoc software would be nice, but I'm...
December 14, 2011 at 11:32 am
Viewing 15 posts - 151 through 165 (of 698 total)