Viewing 15 posts - 1 through 15 (of 25 total)
Phil,
Thank you very much for the advice, I used SQL queries in my SSIS package instead of a merge join and created a static table to be truncated each morning....
June 17, 2016 at 11:30 am
Jeff,
Your post couldn't have come in a more timely manner, the time calculation is actually apart of a bigger query which in fact returned the error you mentioned. Is...
June 23, 2015 at 8:25 am
It does, thank you very much Luis. Can you explain how this works? If not that's fine!
June 19, 2015 at 2:01 pm
Imex, thank you for the quick response. I attempted to use your method in my query and it didn't seem to gel well. It works good on its own I...
June 19, 2015 at 9:32 am
[Quote]It could be that it's set to something other than [DT_R8] (double precision float). If, for example, it's set to float [DT_R4], that would explain the problem.[/Quote]
Thank you so much,...
June 4, 2015 at 1:44 pm
So I am a mess here, I can insert the data into the columns but SQL Server is still throwing the same errors. Is there something in SSIS I am...
June 4, 2015 at 11:25 am
Jacob, thank you for the explanation. I reviewed the table structure and I in fact never set a value for (n) so all of the values should work no? In...
June 4, 2015 at 6:43 am
This looks a lot like testing the boundaries of the float datatypes as those exact values are the upper and lower boundaries of float. Do you really need over 300...
June 3, 2015 at 6:47 pm
Martin,
I was actually able to get it working by changing the Data access mode in the OLE DB Destination Editor to "Table or view" from "Table or view - fast...
April 7, 2015 at 9:59 am
I didn't mean the column names, I meant their values.
Specifically the values for ItemGroupCode, Description, ItemOwner, ItemGroup corresponding to a specific ItemNumber. If the description of an item...
February 4, 2015 at 5:03 pm
Nevyn,
The column names will not change, I will read that Stairways article and give it a shot, thank you for the link. I guess my first thought was to do...
February 4, 2015 at 3:14 pm
So there are 5 columns that will need to be inserted if the ItemNumber is missing, I am however only concerned with comparing the ItemNumber column between tables. Because the...
February 4, 2015 at 2:16 pm
It worked, the customer is happy. I can't thank you all enough for your assistance. 🙂
February 4, 2015 at 9:50 am
Nevyn, I have attached a picture of the current results I am receiving. It's showing that I am performing 2,736 attn tests on machine 55242278 for the day of 9/26....
January 16, 2015 at 8:48 am
Wow, what a query! I have a question about the Number of Tests count. It appears that it does a count and as long as the serial number and test...
January 15, 2015 at 9:16 pm
Viewing 15 posts - 1 through 15 (of 25 total)