Viewing 15 posts - 10,621 through 10,635 (of 13,876 total)
raghuldrag (7/20/2012)
==========================================
A-123 Cr ...
July 20, 2012 at 3:22 am
OK, I thought about this a bit harder.
How about this?
(@LoopRecordCountPrimary+@LoopRecordCountSecondary)==0
July 19, 2012 at 6:35 am
emmadcst (7/19/2012)
July 19, 2012 at 5:11 am
anna-marie.barrington (8/4/2010)
Hello,could you tell me where to find Project Properties, Debugging and setting Run64BitRuntime to false.
Thanks
It's in Visual Studio. While editing a package, select the 'Project' menu item and then...
July 19, 2012 at 3:31 am
I must be missing something (seems too obvious), but surely something like this?
(LoopRecordCountPrimary > 0) || (@LoopRecordCountSecondary > 0)
July 19, 2012 at 3:21 am
May I suggest that you try implementing this (your SQL code) as an SSIS expression, rather than by using parameters. It's worked for me in the past ...
July 18, 2012 at 6:09 am
Yeah, you'll be needing a SQL/XML ninja for that explanation:w00t: I only found that function today while hunting for a solution to your problem and I haven't yet got to...
July 17, 2012 at 1:46 pm
Out of interest, can you explain why you need this?
Should be easy enough via some dynamic SQL - not sure it will be possible otherwise.
July 17, 2012 at 10:06 am
There should be no issue at all if you go down the path you suggest in your last sentence. You are not updating data, merely reading it.
July 17, 2012 at 9:22 am
In this case, as far as I can see, a UDF is your most straightforward solution. I quite like this one:
create function dbo.StripHTML( @text varchar(max) ) returns varchar(max) as
begin...
July 17, 2012 at 6:23 am
debanjan.ray (7/17/2012)
While inserting into destination table through SSIS, some times I am getting a peculiar error. Some times few rows are rejected without any reason. While re-executing those DFTs those...
July 17, 2012 at 5:40 am
Between the source and destination, are you doing any lookups?
July 17, 2012 at 4:22 am
INSERT and INSERT INTO are identical - INTO is there only as a readability aid.
July 16, 2012 at 12:51 pm
There is no simple way of doing this.
I can think of three possibilities:
1) Output each row as a single column - you'll have to concatenate all the columns and add...
July 13, 2012 at 9:53 am
That does not look like a data conversion. After removing the quotes, I think you may need one of these.
July 13, 2012 at 4:26 am
Viewing 15 posts - 10,621 through 10,635 (of 13,876 total)