Viewing 15 posts - 46 through 60 (of 70 total)
I was advised previously that using SSIS for this was not really going to give me a performance boost compared to running a insert into with the case statements defined,...
November 19, 2014 at 4:55 am
Thanks will try that, still is strange that SQL Server destination complains but OLE Destination does not. I just read elsewhere that SQL Server destination may be dropped in future...
November 18, 2014 at 6:45 am
Hi
I have something very similar but there are nulls involved, not sure how this will affect the script.
The field want to use derived column is a field with say 12...
November 4, 2014 at 5:14 am
Thanks, makes sense what you say, I will though then keep the insert into in a SQL Task, as we are adding all the other tables via SSIS, the...
October 29, 2014 at 6:50 am
The issue with this really strange data is that I need to get a way to do a fast load of the data if this is going to be possible,...
October 29, 2014 at 6:21 am
I see you point but this data is weird and we do have substrings for example for 4,6 or 6,20, so some of the values may in fact be nulls
So...
October 29, 2014 at 6:14 am
Would that also work for this Case statement
CASE
WHEN Sample IS NULL
THEN NULL
WHEN SUBSTRING(REPLICATE('0', 9 - LEN(Sample )) + CAST(Sample AS VARCHAR(9)), 1, 3) IS NULL
THEN 0
ELSE RTRIM(SUBSTRING(REPLICATE('0', 9 -...
October 29, 2014 at 6:00 am
Does this procedure also pick up Indexes? It does not look like it in the Valid Object type list. How can I add Indexes to this search?
September 25, 2014 at 6:51 am
In brief here is what I have
A variable number of tables, each of them have field names ID and Index0, they each also have 1-3 data fields. I need to...
August 27, 2014 at 4:58 am
I have had a look at these and nothing really solved the issues in SSIS, I think I need to build this into SSIS, just not sure exactly what to...
August 27, 2014 at 4:06 am
Hi
Thanks so much, I will start testing it and see what it does exactly, and how it fits on our tables. I will get back asap to let you...
August 12, 2014 at 6:49 am
I will try that with a trace, we have looked at using top, but it has not been very effective. The only difference between the two is one gets copied...
August 12, 2014 at 5:31 am
This is the cursor specifically where I picked up the problem
DECLARE @object_id INT
DECLARE @table_name VARCHAR(128)
DECLARE @col_name VARCHAR(128)
DECLARE @exec_sql_string VARCHAR(500)
DECLARE @exec_sql NVARCHAR(500)
DECLARE @max_id NVARCHAR(4000)
DECLARE @OutputParameter NVARCHAR(4000)
DECLARE @id_count NUMERIC(38, 0)
DECLARE @id_count_to NUMERIC(38,...
August 12, 2014 at 4:57 am
Thanks I will have a look at what you said, check the settings etc.
The cursors we use look for a table table and field name, and for example if...
August 12, 2014 at 4:15 am
Maybe I am being a bit slow, but explain to me exactly how to compare the two.
I would also like to find out why everyone is saying do not use...
August 12, 2014 at 2:33 am
Viewing 15 posts - 46 through 60 (of 70 total)