Viewing 15 posts - 8,251 through 8,265 (of 13,876 total)
This suggests a change to the package has been made.
It suggests that the package protection level (see here) has been set to encrypt sensitive with user key.
July 17, 2015 at 4:59 am
mohammed.mazahr (7/17/2015)
I would like your help in solving the following issue using the Patindex function i cannot retrieve or extract the single numeric value as an example in...
July 17, 2015 at 4:48 am
nidhi.naina (7/17/2015)
Then how about Left(Capacity,1) = '-'
Why are you ignoring my suggestion?
July 17, 2015 at 4:43 am
nidhi.naina (7/17/2015)
select * from table WHERE ISNUMERIC(LTRIM(RTRIM(Capacity))) = 1 AND Capacity < '0'
It is working fine...
July 17, 2015 at 3:45 am
nidhi.naina (7/17/2015)
July 17, 2015 at 3:24 am
TJAYWHY (7/16/2015)
Yes I finally did see that...was looking for something like "update"...Thanks!
You are not alone! This has been raised before and, for reasons which are beyond my comprehension, dismissed as...
July 16, 2015 at 11:56 am
sqlnaive (7/16/2015)
Error: 2015-07-16 10:15:40.57
Code: 0x80004005
Source: Generate Sales Data File
Description:
End Error
Error: 2015-07-16...
July 16, 2015 at 11:34 am
Can you get a more comprehensive set of errors from the 'All Executions' report in SSISDB?
July 16, 2015 at 10:20 am
.... up to and including the "F" word
Foxbase?
July 16, 2015 at 9:14 am
allarmi (7/16/2015)
Hello,is there any way to have sqlserver to terminate the current batch when that situation is detected ?
Thank you
Terminate = roll back? Or what, exactly?
may be...
July 16, 2015 at 8:11 am
And if that means deleting millions of rows in any of the tables, you should consider implementing a batch delete process to avoid excessive locking and TLog growth.
July 16, 2015 at 8:08 am
Some ideas:
1) Add a script task to conditionally delete the file before trying to import it.
2) Call a batch file to delete all files of 0 bytes before trying to...
July 16, 2015 at 5:15 am
Brandie Tarvin (7/16/2015)
BrainDonor (7/16/2015)
Brandie Tarvin (7/16/2015)
BrainDonor (7/16/2015)
Lynn Pettis (7/15/2015)
July 16, 2015 at 5:09 am
Viewing 15 posts - 8,251 through 8,265 (of 13,876 total)