Viewing 15 posts - 61 through 75 (of 681 total)
Do you even need the table variable? Seems to me that you are creating the table variable strictly for the purpose of performing a relatively trivial update on the result...
August 2, 2015 at 10:16 am
Agreed, Jeff - if it's qualified with quotes or some other character, it's a much easier problem to solve.
Lacking that, to the OP, I would expect that a problem such...
August 2, 2015 at 10:12 am
I recently wrote this blog post[/url] in which I reference the article you mentioned, and I show how to use code to handle multiple result sets. It's not specific to...
August 1, 2015 at 7:55 am
If your data has literal CRLF characters in the data, SSIS won't know the difference between a CRLF that is supposed to be part of the data and a CRLF...
August 1, 2015 at 7:48 am
Agree with Phil here - Biml is the way to go. It'll take some time to build it out, but once the Biml code is in your library you'll be...
July 15, 2015 at 6:12 pm
If your colleague executes the package from SSDT or BIDS, it will automatically save before executing.
Also, if you are using source control, it might be causing a check-out when the...
July 7, 2015 at 9:27 am
To clarify, there are two different issues you're describing:
-- Warning about performance DLLs
-- Temp table use in SSIS
For the first one, this is a warning only and not an error....
July 7, 2015 at 9:24 am
It could be any number of issues. Can you add a data viewer to include both the PinNumber column and the PinNumber variable into the data flow? This would allow...
July 7, 2015 at 9:15 am
You can populate a result set using a query, and then use a For Each Loop in SSIS to loop through the resulting output. Though your setup would likelier be...
April 25, 2015 at 9:29 am
I'm afraid my Rangers are going to be sub .500 this year. No superstar starter, questionable rotation, no solid closer, and lots of guys just coming back from injury. LAA...
March 31, 2015 at 1:46 pm
If you are unable to sort the data in the source, yes, you would have to sort the data in the data flow before you can use the merge join...
March 30, 2015 at 12:02 pm
I agree with Koen that, if it's an option, doing the join in the source will give you the best results. However, if that's not an option, you can...
March 30, 2015 at 11:45 am
To my knowledge, there's no way to generate an XSD on the fly at runtime. At design time, yes - you can do this using the XML source to generate...
March 23, 2015 at 10:25 am
Adam, thanks for the mention! 🙂
October 21, 2014 at 11:37 am
Viewing 15 posts - 61 through 75 (of 681 total)